Hiding Workbook tabs

[nbannon]

I want to hide all of the workbooktabs in my spreadsheet. I'm guessing I can use the following code:

Windows.DisplayWorkbookTabs = False

The problem is, I don't know where to put the code, or how to invoke it ?

Cheers
Noel.

 

[Mark W.]

Why don't you click the Tools | Options... menu command's View tab and uncheck the Window option for "Sheet tabs"?
This message was edited by Mark W. on 2002-09-10 15:57

 

[nbannon]

****, I knew that option was there somewhere - cheers mate.

 

[nbannon]

I'm still interested in coding it though - any ideas ?

 

[Mark W.]

When in doubt... Record it... and you get...

ActiveWindow.DisplayWorkbookTabs = False
This message was edited by Mark W. on 2002-09-10 16:35

 

[Juan Pablo González]

The code is almost right...

put it in a Standard module, should be something like

Sub HideTabs()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

 

[nbannon]

Next Question - can I automatically hide toolbars ?

 

[Juan Pablo González]

On 2002-09-10 16:14, Mark W. wrote:
When in doubt... Record it... and you get...

ActiveWindow.DisplayWorkbookTabs = False
This message was edited by Mark W. on 2002-09-10 16:35

Ahh... I forgot to quote you ! But, yes, I agree. That is the best source of "good" VBA syntax