| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding the Insert New Worksheet tab in Excel 2007
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Insert New Worksheet tab in Excel 2007
commandbars("Ply").Controls("Insert...").Visible=F alse
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Insert New Worksheet tab in Excel 2007
Hi Bob
I think the OP want to remove the button next to the last tab Bob Not the insert option in the right click menu Don't know a solution for this. No time to try because I must go to my father (father's day) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... commandbars("Ply").Controls("Insert...").Visible=F alse -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Insert New Worksheet tab in Excel 2007
Hi Jeff/Bob
I think protecting the workbook is the only thing to disable the insert button next to the last sheet tab -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Bob I think the OP want to remove the button next to the last tab Bob Not the insert option in the right click menu Don't know a solution for this. No time to try because I must go to my father (father's day) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... commandbars("Ply").Controls("Insert...").Visible=F alse -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
