How to Prevent User from Unhiding Sheet
 

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!

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!

How to Prevent User from Unhiding Sheet
 

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

HTH
Paul

-----------------------------------------

On Tue, 16 Sep 2003 13:26:51 -0700, Bruce B
wrote:


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!

How to Prevent User from Unhiding Sheet
 

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


"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!

How to Prevent User from Unhiding Sheet
 

Hi Bruce

I use xl97 but think this might work for you

Sheets("yoursheet").Visible = xlSheetVeryHidden

Tony.


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!