Setting password on worksheet in Excel 2000

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Has anyone had the problem of setting a password on a worksheet in Excel
2000 (MS Office 2000 Pro. Suite). It will let me go through the routine of
creating the password and it indicates that a password has been set, but
when I reopen the spreadsheet it doesn't ask me for the password, it simply
opens to the worksheet.

Any help you can give me on this would be greatly appreciated.

Thanks
William
 
Bill said:
Has anyone had the problem of setting a password on a worksheet in Excel
2000 (MS Office 2000 Pro. Suite). It will let me go through the routine
of
creating the password and it indicates that a password has been set, but
when I reopen the spreadsheet it doesn't ask me for the password, it
simply
opens to the worksheet.

Any help you can give me on this would be greatly appreciated.

Thanks
William
Click to expand...

William,

Did you use the Protect function? This just stops people changing values in
protected cells. It is a very limited functionality and the Microsoft Help
will tell you that it is not designed to keep your data secure.

If you did use Protect then you will only be asked for the password when you
try to unprotect.

Thomas
 
Bill

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
 
Back
Top