How to change the macro called by an add in from older excel?

[Ian]

I have the new 2007 version and many macros written over the years that I had
in older versions of excel as toolbars. Some I use at home some are used in
other businesses for access control and document management. Now I can Add
the toolbars in to the new version, but I can't see a way to edit the buttons
to point at the macros themselves which are in another workbook, which has
also moved location since the install. I could do this programmatically, but
right now I'm hoping that I'm missing something obvious and simple in the
other menus. Does anyone know where this is.
In older versions you could edit the toolbar whilst the customise option was
open.

I'm so irritated that I might even un-install this expensive new version for
an old '95 I have on the shelf.

 

[caldog]

I have the new 2007 version and many macros written over the years that Ihad
in older versions of excel as toolbars. Some I use at home some are used in
other businesses for access control and document management. Now I can Add
the toolbars in to the new version, but I can't see a way to edit the buttons
to point at the macros themselves which are in another workbook, which has
also moved location since the install. I could do this programmatically, but
right now I'm hoping that I'm missing something obvious and simple in the
other menus. Does anyone know where this is.
In older versions you could edit the toolbar whilst the customise option was
open.

I'm so irritated that I might even un-install this expensive new version for
an old '95 I have on the shelf.

I read somehwere fairly recently that in Excel 2007 Microsoft disable
the users from having a Macro toolbar.

Just my two cents worth.

Steve

 

[Ron de Bruin]

Hi Ian

Check out this page
http://www.rondebruin.nl/qat.htm

See also the other pages in my 2007 section