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
|DSS Home | About Us | Contact Us | Site Index | Subscribe | What's New|
Copyright © 1995-2013 by D. J.
Power (see his home page).|
DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at firstname.lastname@example.org with questions. See disclaimer and privacy statement.