View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Prevent unhide sheet

Hi,

Try this:
1. Right click any toolbar and turn on Control Toolbox
2. Click the Properties button
3. Change the Visible property to xlVeryHidden
4. Press Alt+F11 and select your workbook in the Project window.
5. Choose Tools, VBA Project Properties,
6. Choose Protection and check Lock project for viewing and add a password.
7. Close the file and reopen it.

All passwords can be broken, but some are easier to break than others.

--
Thanks,
Shane Devenshire


"acss" wrote:

I know how to hide a sheet but i do i prevent a user from performing the
unhide? Does it have to be done using VB or hiding a particular toolbar?

Thanks,