Hiding the Insert New Worksheet tab in Excel 2007

[jgrob3]

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

 

[Bob Phillips]

commandbars("Ply").Controls("Insert...").Visible=False


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron de Bruin]

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)

 

[Ron de Bruin]

Hi Jeff/Bob

I think protecting the workbook is the only thing to disable the insert button next to the last sheet tab