Sheets Tabs Function
 

Hi all,

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

Thanks all

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=51733

Sheets Tabs Function
 

Try

ActiveWindow.DisplayWorkbookTabs = _
Not ActiveWindow.DisplayWorkbookTabs

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


"gti_jobert"
wrote
in message
...

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

Sheets Tabs Function
 

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


--
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