Show/Hide tabs on one button

**lukestkd** · 02-22-2013, 01:36 PM

Hi all,
I have a basic question that I just don't know the answer to!

I want to vba a button to show/hide tabs. I have the code to hide tabs:

Sub Hide_Tabs()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

How do I add to the code so the buton shows on click then hides on click (and repeats)?

Many Thanks!

Luke

**OllieB** · 02-22-2013, 01:49 PM

Hi Luke,

Sub Hide_Tabs()
ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs
End Sub

**lukestkd** · 02-22-2013, 02:08 PM

Cheers Ollie! Working perfectly. Will the = work for any vba on a button for click action click another action?

Cheers, Luke

**OllieB** · 02-22-2013, 02:14 PM

The '= not' will work for other switch on/off situations

Re: Show/Hide tabs on one button