hi,


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

thanks in advance...


Lawrence

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!


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Lawrence" wrote in message
...
hi,


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

thanks in advance...


Lawrence

sorry...

can i send to your email address, coz i still can't do it..



"Arvi Laanemets" wrote:

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!


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Lawrence" wrote in message
...
hi,


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

thanks in advance...


Lawrence

What is ur real email address, i can't assess into arvil<attarkon.ee


lawrence

"Arvi Laanemets" wrote:

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!


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Lawrence" wrote in message
...
hi,


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

thanks in advance...


Lawrence

Hi


"Lawrence" wrote in message
...
What is ur real email address, i can't assess into arvil<attarkon.ee


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<attarkon.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?



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )