View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jgrob3@hotmail.com is offline
external usenet poster
 
Posts: 6
Default 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