How do I password protect a spreadsheet

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I have a bunch of spreadsheets that require passwords to open them, both to
read and to write. I put them on myself, but have forgotten what I did, and
I want to apply password protection to a new spreadsheet. The obvious thing
seems to be Tools/Protection/Protect Sheet or Protect Workbook. But when I
do either one of these, it only write protects, it does not cause a password
to be required to open the .xls file. Can someone remind me of what I did
to require a password to open the .xls file?
 
Laurel

Assuming Excel 2000, use File -> Save As, then click on Tools and
General Options. This should give you the prompts for the passwords.

Regards

Murray
 
Back
Top