Make Workbook Password protected tp open

S

Stockwell43

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.

Thanks!!
 
K

Kevin B

Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at
the top of the file list on the right is a TOOLS drop down list. Click the
TOOLS drop down button and select GENERAL OPTIONS. You can set a password to
open the file, and if you want to limit who can modify it another password to
make changes to the file.
 
S

Stockwell43

Excellent, thanks Kevin!!

Kevin B said:
Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at
the top of the file list on the right is a TOOLS drop down list. Click the
TOOLS drop down button and select GENERAL OPTIONS. You can set a password to
open the file, and if you want to limit who can modify it another password to
make changes to the file.
Click to expand...
 
B

Bruce Sinclair

Open Help, look up "Open with password"
Click to expand...

Note, however, that ther are many password crackers/removers out there. XL
passwords will not stop someone that really wants to see the spreadsheet.
If there's stuff you don't want seen, don't include it. :)
 
Top