Show/Hide tabs on one button

[lukestkd]

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:

Please Login or Register  to view this content.

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

Many Thanks!

Luke

[OllieB]

Hi Luke,

Please Login or Register  to view this content.

[lukestkd]

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

Cheers, Luke

[OllieB]

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