How to Prevent User from Unhiding Sheet

  • Thread starter Thread starter Bruce B
  • Start date Start date
B

Bruce B

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
 
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
 
Alt-F11to open VBE. Select the sheet. F4 to display Properties window.
Set Visible property to xlSheetVeryHidden. Protect the project.

HTH
Paul
 
The xlVeryHidden advice given so far is the best solution you have, but
beware that you should not assume it is foolproof. It is fairly trivial to
crack.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in
 
Hi Bruce

I use xl97 but think this might work for you

Sheets("yoursheet").Visible = xlSheetVeryHidden

Tony.
 
Back
Top