 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2006Is there a Password function
For Example say cell A1 requires a password for the rest of the spreadsheet to work and this password can only be input correctly 5, then the spreadsheet stops working. Is the a way to do this?  Signaturesammberg There are several types of password protection. 1. Password to open the file. Can be set at File>Save As>Tools>General Options. 2. Password on a protected worksheet. This is set at Tools>Protection>Protect Sheet. Many functions can be disabled using this type of protection. 3. Workbook Protection password. This is set at Tools>Protection>Protect Workbook. This protects the workbook from having sheets deleted and other functions disabled. NOTE: except for File to Open protection, most forms of Excel protection are very weak and passwords can be easily cracked. Gord Dibben MS Excel MVP >For Example say cell A1 requires a password for the rest of the >spreadsheet to work and this password can only be input correctly 5, >then the spreadsheet stops working. > >Is the a way to do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.