Sheets Tabs Function

[gti_jobert]

Hi all,

Is it possible to have a function on a cmdbutton in a userform to show/hide sheet tabs??

Thanks all.

[Chip Pearson]

Try

ActiveWindow.DisplayWorkbookTabs = _
Not ActiveWindow.DisplayWorkbookTabs

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"gti_jobert"
<[email protected]> wrote
in message
news:[email protected]...
>
> Hi all,
>
> Is it possible to have a function on a cmdbutton in a userform
> to
> show/hide sheet tabs??
>
> Thanks all.
>
>
> --
> gti_jobert
> ------------------------------------------------------------------------
> gti_jobert's Profile:
> http://www.excelforum.com/member.php...o&userid=30634
> View this thread:
> http://www.excelforum.com/showthread...hreadid=517332
>

[gti_jobert]

Cheers boss, have got it working with your help now!