| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking Sheet Tabs as Hidden
A small problem ...
I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Thanks in advance Ted |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
One way is to modify the command bar, disabling the item. Don't have the
code at hand but have done this in the past. "Ted" wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Thanks in advance Ted |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
Ted wrote:
A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
I think the OP wants to hide the Tabs rather than the sheets
"Dick Kusleika" wrote: Ted wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
He says he knows how to set the Sheet Tabs to hidden - sounds like he wants
to see how to hide the sheets and prevent the user from unhiding them. Hidding the tabs was one (unsuccessful attempt). If you reread it, do you disagree? -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... I think the OP wants to hide the Tabs rather than the sheets "Dick Kusleika" wrote: Ted wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''
how I can stop the user from going to the Tools-- Options menu and unhiding them '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''' The above is what leads me to think the OP is only concerned with the TABS, rather than the visibility of the SHEETS themselves. Going to ToolsOptions leads the user to the location for hiding/unhiding the TABS. While sheets are hidden/unhidden thru the Format menu. In order to prevent a user from unhiding the TABS (of visible sheets) the developer could disable either the Option menu, the Tools menu or create a new custom Menubar minus the Option menu. "Tom Ogilvy" wrote: He says he knows how to set the Sheet Tabs to hidden - sounds like he wants to see how to hide the sheets and prevent the user from unhiding them. Hidding the tabs was one (unsuccessful attempt). If you reread it, do you disagree? -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... I think the OP wants to hide the Tabs rather than the sheets "Dick Kusleika" wrote: Ted wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
Perhaps you are correct. For the methods you suggest, I only see macros as
an option to perform these modifications. In which case, disabling macros is less complicated then going to tools=options. In any event, I don't see what is to be gained by hiding the tabs if the sheets can be hidden. Perhaps the OP should be advised that excel is not a very good platform for security enforcement. -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''' how I can stop the user from going to the Tools-- Options menu and unhiding them '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''' The above is what leads me to think the OP is only concerned with the TABS, rather than the visibility of the SHEETS themselves. Going to ToolsOptions leads the user to the location for hiding/unhiding the TABS. While sheets are hidden/unhidden thru the Format menu. In order to prevent a user from unhiding the TABS (of visible sheets) the developer could disable either the Option menu, the Tools menu or create a new custom Menubar minus the Option menu. "Tom Ogilvy" wrote: He says he knows how to set the Sheet Tabs to hidden - sounds like he wants to see how to hide the sheets and prevent the user from unhiding them. Hidding the tabs was one (unsuccessful attempt). If you reread it, do you disagree? -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... I think the OP wants to hide the Tabs rather than the sheets "Dick Kusleika" wrote: Ted wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking Sheet Tabs as Hidden
I'm not sure I understand how you would accomplish preventing the user from
unhiding TABS just by disabling macros. In fact, ToolsOptions is still available with or without macros. Personally I have developed apps where screen real estate was a premium hence I hid the col/row headers and Tabs, while keeping sheets visible, but accessible thru navigational buttons - ie all menu-driven. I didn't want the user to go to ToolsOptions to unhide the Tabs so I created a custom menu bars in some cases and disabled menu items in other cases. "Tom Ogilvy" wrote: Perhaps you are correct. For the methods you suggest, I only see macros as an option to perform these modifications. In which case, disabling macros is less complicated then going to tools=options. In any event, I don't see what is to be gained by hiding the tabs if the sheets can be hidden. Perhaps the OP should be advised that excel is not a very good platform for security enforcement. -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''' how I can stop the user from going to the Tools-- Options menu and unhiding them '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''' The above is what leads me to think the OP is only concerned with the TABS, rather than the visibility of the SHEETS themselves. Going to ToolsOptions leads the user to the location for hiding/unhiding the TABS. While sheets are hidden/unhidden thru the Format menu. In order to prevent a user from unhiding the TABS (of visible sheets) the developer could disable either the Option menu, the Tools menu or create a new custom Menubar minus the Option menu. "Tom Ogilvy" wrote: He says he knows how to set the Sheet Tabs to hidden - sounds like he wants to see how to hide the sheets and prevent the user from unhiding them. Hidding the tabs was one (unsuccessful attempt). If you reread it, do you disagree? -- Regards, Tom Ogilvy "gocush" /delete wrote in message ... I think the OP wants to hide the Tabs rather than the sheets "Dick Kusleika" wrote: Ted wrote: A small problem ... I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can stop the user from going to the Tools-- Options menu and unhiding them (which makes hiding them a bit pointless). What am I missing? Ted: Set the Visible property to xlSheetVeryHidden. The only way to unhide it will be through VBA. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking Sheet Tabs | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| How can I find/unhide hidden excel sheet tabs on a worksheet? | Excel Worksheet Functions | |||
| Sheet tabs are hidden...option is checked | Excel Discussion (Misc queries) | |||
| locking tabs w/macros | Excel Discussion (Misc queries) | |||
![Ted[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
