![]() |
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? |
How do I password protect a spreadsheet
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 |
How do I password protect a spreadsheet
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 |
All times are GMT +1. The time now is 12:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com