Often Spreadsheet-based DSS are distributed to multiple users in a company. This practice can lead to problems and hence many developers want to take steps to reduce the chance that the DSS will be changed or corrupted. One answer is to protect the application. To protect a Spreadsheet-based DSS built using MS Excel choose Tools|Protection|Protect Sheet. When the Protect Sheet
dialog box opens, type in a password. Re-enter the password
when requested and then click OK. A developer needs to plan
carefully what cells will and will not be protected.
appeared in DSS News 02/17/02 |