Toolbar macro re-named

[Dan]

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!

 

[Dave Peterson]

You may find your life becomes much easier by using code to do this work.

You can include code to create the toolbar when the workbook is opened and
include code to destroy the toolbar when the workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl
or
http://www.rondebruin.nl/ribbon.htm

 

[Gord Dibben]

Place your macros into a new workbook and save it as an add-in.

Load that through Tools>Add-ins.


Gord Dibben MS Excel MVP

 

[Dan]

Gord -
You'll have to talk slower
I opened a new worksheet, saved it as an addin.
If I select the addin using Tools>Addins, what next?
If I use my tool bar (under View>Toolbars) it still seems to want to find
the macro somewhere else.
Thanks!

 

[Tim Zych]

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.