Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How reassign toolbar button ??
Hi David,
Adding to Tom's comment: Toolbars are stored in your .XLB file and applies to your use of Excel not to a particular workbook or to a particular worksheet. Best to place the macro in your personal.xls workbook and assign the macro to run from there. I have a page on toolbars if you're not too overwhelmed with all your other problems: http://www.mvps.org/dmcritchie/excel/toolbars.htm since it looks like you are overwhelmed you probably definitely want to be sure you are taking backups. http://www.mvps.org/dmcritchie/excel/backup.htm HTH, it David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tom Ogilvy" wrote in message ... You would bring up tools=customize, then right click on the button and change the macro assigned to the button. in code, you would reassign using the onaction property. -- Regards, Tom Ogilvy "David" wrote in message ... I have a toolbar button set to run a macro but somehow it is running a macro in another workbook. How do I reassign the button to run the macro from the same workbook? I looked in Help but it only says how to set up a button not how to reassign it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar button | Excel Discussion (Misc queries) | |||
code to reassign a macro to a toolbar button because of path change | Excel Discussion (Misc queries) | |||
New button on toolbar | Excel Worksheet Functions | |||
Sum Button Toolbar | Excel Discussion (Misc queries) | |||
How reassign toolbar button ?? | Excel Programming |