Toolbar macro re-named

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 18 Dec 2007 23:17 GMT

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 to this Message

Dave Peterson - 18 Dec 2007 23:50 GMT

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

> I have created a toolbar, and assigned macros to the various buttons.
> However, excel has added the filename to the macro assignment.
[quoted text clipped - 10 lines]
>
> Thanks in advance!

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 18 Dec 2007 23:52 GMT

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

>I have created a toolbar, and assigned macros to the various buttons.
>However, excel has added the filename to the macro assignment.
[quoted text clipped - 10 lines]
>
>Thanks in advance!

Reply to this Message

Dan - 19 Dec 2007 00:07 GMT

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!

> Place your macros into a new workbook and save it as an add-in.
>
[quoted text clipped - 16 lines]
> >
> >Thanks in advance!

Reply to this Message

Tim Zych - 19 Dec 2007 08:38 GMT

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.

Signature

Tim Zych
SF, CA

>I have created a toolbar, and assigned macros to the various buttons.
> However, excel has added the filename to the macro assignment.
[quoted text clipped - 11 lines]
>
> Thanks in advance!

Reply to this Message