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

Thanks very much.

"Murray" wrote in message
oups.com...
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