Password protecting a worksheet

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
 
S

swatsp0p

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
 
H

Harlan Grove

[email protected] 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...
 
Top