Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Has anyone figured out whether it's possible to hide Excel 2007's
"Insert new worksheet" tab that appears with the other sheet tabs at the bottom of the screen? I have an application where I don't want users inserting any new sheets but would still like to show them what tab they're on. I know I can hide all worksheet tabs very easily using ActiveWindow.DisplayWorkbookTabs = False or similar but I only want to hide the "Insert new worksheet" tab. Is this possible or is the only way around it to prevent it via workbook protection? Workbook protection is OK but the user can still see the tab - they just can't click on it. You'd think it'd be a property of the ActiveWindow but I can't see it there. Any ideas? tia Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Page Numbers on Worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
Hiding rows in Excel 2007 | Excel Discussion (Misc queries) | |||
EXCEL 2007 - INSERT NEW WORKSHEET | Excel Worksheet Functions | |||
Set up custom insert worksheet tab in excel 2007 | Setting up and Configuration of Excel | |||
How to insert a CheckBox in a Excel 2007 worksheet?? | Excel Worksheet Functions |