Hide and password protect a worksheet

  • Thread starter Thread starter Oldjay
  • Start date Start date
O

Oldjay

I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook
 
Oldjay said:
I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook
Click to expand...

Hello Oldjay:

Go to Tools, Protection and then Protect sheet
 
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.
 
Thanks for the info

Jim Thomlinson said:
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.
Click to expand...
 
Back
Top