| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets Tabs | Excel Discussion (Misc queries) | |||
| 52 Work sheets (Tabs) | New Users to Excel | |||
| Hiding tabs for just some sheets. | Excel Worksheet Functions | |||
| add a header and or footer to all sheets/tabs | Excel Discussion (Misc queries) | |||
| Naming Sheets Tabs | Excel Worksheet Functions | |||
![gti_jobert[_42_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
