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

DSS Home | About Us | Contact Us | Site Index | Subscribe | What's New
Copyright © 1995-2008 by D. J. Power (see his home page).
DSSResources.COM^sm is maintained by Alexander P. Power and Daniel J. Power. Please contact them at webmaster@dssresources.com with questions. See disclaimer and privacy statement.

DSS Home \| About Us \| Contact Us \| Site Index \| Subscribe \| What's New
	Copyright © 1995-2008 by D. J. Power (see his home page). DSSResources.COM^sm is maintained by Alexander P. Power and Daniel J. Power. Please contact them at webmaster@dssresources.com with questions. See disclaimer and privacy statement.