Add button to toolbar

D

dew

Using VBA I want to add a button to the toolbar that will run a macro. The
recorded macro follows. It doesn't put a name on the button and I want to do
that.

Thanks.

CommandBars("Standard").Controls.Add Type:=msoControlButton, ID:=40001,
Before:=29, Parameter:="Macro ""Module9.TestFont"""
 

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

Select Text to End of Footnote 9
Macro will not be assigned to a toolbar button. 0
Can I edit macro buttons on the quick access toolbar in excel? 0
Save workbook without shapes 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Onaction not working in Project 2007 3
Creating toolbar with button text 0
CommandBar and Controls (how to create separate "Sets" of Controls) 4

Top