View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria[_2_] Jacob Skaria[_2_] is offline
external usenet poster
 
Posts: 5
Default Password Protect Unhide Worksheet?

Launch VBE using Alt+F11.
On the left hand side treeview; click the sheet to be hidden. This will open
up the properties for that sheet. Set Visible property to 2- xlVeryHidden.

If you need you can password protect VBE from menu Tools|VBA Project
properties|Protection


If this post helps click Yes
--------------
Jacob Skaria


"garyh" wrote:

Is there a way to password protect a worksheet so that the user cannot UNHIDE
the worksheet unless she/he knows the password?

Thanks, in advance, for your help.

G