ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I password protect a spreadsheet (https://www.excelbanter.com/new-users-excel/62386-how-do-i-password-protect-spreadsheet.html)

Laurel

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?



Murray

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


Laurel

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