Protect hide worksheet

L

Lawrence

hi,


could anyone tell me how to protect hide worksheet so that people couldn't
unhide the worksheet.

thanks in advance...


Lawrence
 
A

Arvi Laanemets

Hi

1. Activate VBA editor (Alt+F11)
2. In VBA-Project window (the leftmost upper one), select the worksheet you
want to hide.
3. In Properties window (below VBA-Project vindow - when you don't have such
one there, then activate it from menu), set the Visible property for
worksheet to xlSheetVeryHidden.
4. In VBA-Project window, right-click on your project (with your workbook's
name in brackets), and select VBA-Project Properties from drop-down menu.
Activate Protection tab, and enter password for VBA-project (otherwise any
user can change sheet's Visible property back to xlSheetVisible). OK.
5. Close VBA editor. There you are!
 
A

Arvi Laanemets

Hi


Lawrence said:
What is ur real email address, i can't assess into arvil<at>tarkon.ee
Click to expand...


You have to edit it slightly (replace "<at>" with one character proper for
mail address. I'll never use my full mail address anymore, where search
robots can find it - various NG's are popular source for spammers).
Btw. you better use the address arvi.laanemets<at>tarkon.ee instead (again,
replace <at> there) - the old one works as far I know, but who knows:)

Btw. when you weren't able to follow instructions, and want to send the file
so I hide the sheet, then I'm afraid you aren't able to make the sheet
visible later too. Maybe you better try to hide it yourself yet and make
yourself to understand the process - where did you get stucked at all?
 
Top