Spreadsheet password protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you password protect a spreadsheet. I can't find anything in the help
section.
 
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
 
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
 
You must log in or register to reply here.

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
Excel Protection 2
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
UNLOCK PASSWORD 2

Back
Top