How to Prevent User from Unhiding Sheet

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


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

Jake Marx

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
 
P

pfsardella

Alt-F11to open VBE. Select the sheet. F4 to display Properties window.
Set Visible property to xlSheetVeryHidden. Protect the project.

HTH
Paul
 
R

Robin Hammond

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
 
M

mcpheat

Hi Bruce

I use xl97 but think this might work for you

Sheets("yoursheet").Visible = xlSheetVeryHidden

Tony.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent user to unhide Formula Bar 2
Prevent User from Changing Password 2
Need user unable to unhide sheets 2
Hide rows and prevent unhiding 2
Sheets - Limited acces 4
To prevent a user from deleting and renaming a sheet in a workbook 3
Prevent unhide sheet 2
Visible Row? 4

Top