On 2 Des, 05:38, SS wrote:
Folks,
Although very helpful when you need it, it can be a big neusance.
Is there a way to disable or remove from the current worksheet in
2010?

Thanks!
-Steve
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
Hi, Steve.

I don't think it is possible to disable the worksheet Tabs and having
them visible at the same time without protecting the whole workbook.

However, if you mean Hiding the worksheet tabs at the bottom of the
worksheets, you can use this method:

Sub HideWBtabs()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

To get them visible again, change the word False with True and run the
code again..

Or manually ...

Go to the File Tab to the very Left on the Ribbon, go to Advanced and
uncheck Show WorksheetTabs.

Hope that gave you some extra ideas...

Regards



Jan T.