Protect Spreadsheet-based DSS

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