Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |