Password protecting a worksheet

  • Thread starter Thread starter mickeyfinn6999
  • Start date Start date
M

mickeyfinn6999

Hi all,

I am trying to find out whether it is possible to password protect a
worksheet within a workbook.

I have 3 worksheets in my workbook and want to allow the user access to
2 of them. The 3rd one I dont want to allow the user any access (not
even to view the contents) unless they have a password.

Is this possible?

Many thanks
 
Hide your desired sheet, Protect the workbook with a password (don't
lose the password). Save the file, close the file, reopen the file.
You now need to unprotect the workbook to be able to unhide the sheet.

HTH

Bruce
 
(e-mail address removed) wrote...
I am trying to find out whether it is possible to password protect a
worksheet within a workbook.
Click to expand...
....

If you had checked online help, entering either password or protect as
the search term, you would have had an answer much sooner.

Tools > Protection > Protect Sheet...
 
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

Excel Protection 2
Different password for different worksheet 11
allow a user to edit ranges in a protected worksheet 3
Worksheet Protection / Security from Viewing 1
Password protected macro 3
Different Passwords for different worksheets in one workbook 8
Protect a worksheet with a password 2
Copy protection from one worksheet to another 2

Back
Top