View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx Jake Marx is offline
external usenet poster
 
Posts: 22
Default How to Prevent User from Unhiding Sheet

Hi Bruce,

Make the sheet xlVeryHidden:

Worksheets("Sheet1").Visible=xlSheetVeryHidden

Note: you should protect your VBA project with a password as well. This
will help keep people from unhiding the sheet through the object properties.

Regards,

Jake Marx
MS MVP - Excel


"Bruce B" wrote in message
...

In the application I am developing (Excel 2000), it opens up to a login
sheet and hides all the other sheet.

Is there any way that I can prevent the user from going to Tools --
Sheet -- Unhide to open up the other sheets?

Thx!

- Bruce


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!