| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent unhiding columns | Excel Discussion (Misc queries) | |||
| Hiding Worksheets and Unhiding them easily for Novice User | Excel Discussion (Misc queries) | |||
| How do I prevent hidden rows from unhiding when resizing row ht? | Excel Discussion (Misc queries) | |||
| Prevent User to unlock Sheet Tabs | Excel Worksheet Functions | |||
| Unhiding a sheet | Excel Discussion (Misc queries) | |||
![Bruce B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
