Hide and password protect a worksheet
 

I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook

Hide and password protect a worksheet
 

"Oldjay" wrote:

I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook

Hello Oldjay:

Go to Tools, Protection and then Protect sheet

Hide and password protect a worksheet
 

A couple of possible solutions. You can hide the worksheet and then password
protect the workbook which is reasonably effective at keeping people out out
your worksheet. Note that your workbook must be protected for this to work
and the workbook passwords are relatively easy to break with code that is
readily available.

Another solution is to change the visible property of the worksheet with a
macro. One option is to make the sheet very hidden. Doing this the worksheet
does not show up anywhere via the standard XL menus. Additionally you can
password protect the VB project to keep users out of the VBE which means that
they can not easily unhide the sheet.

All of that being said there is no 100% way to protect users from getting at
the sheet.
--
HTH...

Jim Thomlinson


"Oldjay" wrote:

I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook