Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Button Scope Limitation
I've added a custom toolbar button to my excel program, and it now appears in all excel applications. How can I have it appear just in the program where I want it
Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Button Scope Limitation
Ron,
Use the Activate and Deactivate events to show or hide the command bar. Private Sub Workbook_Activate() Application.CommandBars("MyCommandBar").Visible = True End Sub Private Sub Workbook_Deactivate() Application.CommandBars("MyCommandBar").Visible = False End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "RonF" wrote in message ... I've added a custom toolbar button to my excel program, and it now appears in all excel applications. How can I have it appear just in the program where I want it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom macro and custom button | New Users to Excel | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
Custom Format Limitation | Excel Discussion (Misc queries) | |||
Custom Button Pictures | Excel Discussion (Misc queries) | |||
Custom Button | Excel Programming |