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