Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That's normal behavior if you link a macro to the commandbar. It remembers
the link and opens the linked macro's file if it's not open, then runs the macro. I like to use the Tag and ActionControl to handle menu/commandbar calls. It avoids that problem and is much easier to manage it using code. As far as I know, there's no way to avoid the behavior you see unless you programmatically set up the menu and avoid linking it to a specific workbook. -- Tim Zych SF, CA "Dan" wrote in message ... I have created a toolbar, and assigned macros to the various buttons. However, excel has added the filename to the macro assignment. For example, I have a macro called "StartNewProject". When I assign this macro name to a button on the toolbar, close it, then look at the button again, it has this macro assigned: "<WorkbookName!StartnewProject". Problem is, when I start with a new workbook, it is trying to open the macro in another excel file. How can I keep Excel from preceeding the macro name with the current workbook file name? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TOOLBAR FOR A MACRO | Excel Discussion (Misc queries) | |||
macro in toolbar | Excel Discussion (Misc queries) | |||
macro toolbar | Excel Discussion (Misc queries) | |||
Toolbar with macro | Excel Programming | |||
Macro Help on Toolbar | Excel Programming |