Custom Button Scope Limitation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
I've added a custom toolbar button to my excel program, and it
Click to expand...
now appears in all excel applications. How can I have it appear
just in the program where I want it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toolbars in Excel 2007 6
Adding a Custom Command Button to the Excel 2007 Ribbon 1
Easy way to add my custom button on Excel 2010 quick access toolbar? 3
Macros assigned to Menu Items 2
Customize Quick Access Toolbar 5
Excel 2007 "Custom Toolbars Button" 2
Custom toolbar - how to save in file and show on demand? 3
Custom toolbars in templates 2

Back
Top