John, change the workbook property of your file from True for IsAdd-in to
False. Make certain you do not have option private module at the top of the
module containing the procedure to be assigned to the button. Select View,
Toolbars, Customize. Select the button and then right click on it. Use the
menu item for macro to assign a macro to the button. Then exit the menus.
Change the add-in property back to true.
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"John" wrote in message
...
Hello,
I am trying to add a toolbar button that will run a macro
in any file. The macro that I am trying to run is from a
custom Add-In I have created. This Add-In macro can run
from any file. How can I get the toolbar button to
reference the Add-In Macro, additionally I would like the
toolbar button to appear on my toolbar for every Excel
file I have open (somewhat like a default toolbar button).