Spreadsheet password protection

G

Guest

How do you password protect a spreadsheet. I can't find anything in the help
section.
 
G

Guest

You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
give password.

On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
 
G

Gord Dibben

Most strange.

I type "password" in the Help Wizard and get hits on protecting the worksheet,
workbook, cells, etc.

Perhaps you should see if you have installed all the appropriate files during
your Office installation.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password Protecting Cells 2
Forgot password for Excel 2007 spreadsheet (*.xls) 3
Protect Sheet not allowing insert or delete rows. VBA buttons notsolving problem ? 1
Excel 2007 Sharing Violation when saving a workbook with a passwor 1
Problem In Opening Excel: Thoughts On ? 2
Password Protect 2 columns with different passwords 12
Allowing access to password protected spreadsheets 3
UNLOCK PASSWORD 2

Top