View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Laurel
 
Posts: n/a
Default How do I password protect a spreadsheet

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?