| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Custom Made Toolbar
Hi Guys, Need to know if it is possible to enable/disable/hide/show certai buttons on a custom toolbar I made Thanks Da -- drawling ----------------------------------------------------------------------- drawlings's Profile: http://www.excelforum.com/member.php...fo&userid=3662 View this thread: http://www.excelforum.com/showthread.php?threadid=57174 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Custom Made Toolbar
Hi Dan,
Try something like: '============= Public Sub TesterA01() Dim TBar As CommandBar Set TBar = Application.CommandBars("YourToolbar") '<<==== CHANGE TBar.Controls(1).Enabled = False End Sub '<<============= -- --- Regards, Norman "drawlings" wrote in message ... Hi Guys, Need to know if it is possible to enable/disable/hide/show certain buttons on a custom toolbar I made Thanks Dan -- drawlings ------------------------------------------------------------------------ drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626 View this thread: http://www.excelforum.com/showthread...hreadid=571747 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Custom Made Toolbar
Thanks for your reply. That code works great at disabling the toolbar itself, but I need to disable certain buttons within the toolbar. Example: Toolbar Name: P&L I have 6 buttons in total and I want to disable the second button 'Options'. Button1 = Download Button2 = Options etc..... Thanks Dan -- drawlings ------------------------------------------------------------------------ drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626 View this thread: http://www.excelforum.com/showthread...hreadid=571747 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Custom Made Toolbar
Hi Dan,
That code works great at disabling the toolbar itself, but I need to disable certain buttons within the toolbar. The suggested code does not disable the custom toolbar; it disables only the first control on the toolbar. --- Regards, Norman |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Custom Made Toolbar
Ok, so is there code to disable a button within a toolbar? -- drawlings ------------------------------------------------------------------------ drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626 View this thread: http://www.excelforum.com/showthread...hreadid=571747 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Custom Made Toolbar
Hi Dan,
Yes - try my suggested code. --- Regards, Norman "drawlings" wrote in message ... Ok, so is there code to disable a button within a toolbar? -- drawlings ------------------------------------------------------------------------ drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626 View this thread: http://www.excelforum.com/showthread...hreadid=571747 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy check boxes (made from form toolbar) | Excel Discussion (Misc queries) | |||
| SOS: Excel custom Toolbar | Excel Programming | |||
| Adding a check mark to the custom made toolbar/menu continue...... | Excel Programming | |||
| custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
| How can I get into VBA for a custom toolbar - Excel 97 | Excel Programming | |||
![drawlings[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
