Overloading builtin macros

[Morten Frederiksen]

In Word it is possible to overload builtin macros, so that for example a
macro named "FilesNew" will be invoked when selecting New from the Files
menu. A list of the overloadable can be found when selecting Play macro.

Now I would like to do something similar in Excel, but it does not seem to
be possible. Can this really be true?

Regards
Morten Frederiksen

 

[Greg Koppel]

Hello Morten,

To customize menus in Excel, right click on any toolbar and choose
'Customize' from the list. The dialog must be open to do any customizing.
Next click on the menu you want to change and right click on the menu item.
Choose 'Assign macro' from the list. You can also add items to the menus or
create a completely custom menu.

HTH, Greg

 

[Morten Frederiksen]

Hello Morten,

To customize menus in Excel, right click on any toolbar and choose
'Customize' from the list. The dialog must be open to do any customizing.
Next click on the menu you want to change and right click on the menu item.
Choose 'Assign macro' from the list. You can also add items to the menus or
create a completely custom menu.

Thanks Greg, that solved part of my problem. However, I also would like to
make this customized menu available to all user of Excel on the network. In
Word I simply put a document containing the macros in the the Startup
folder,
and Word will make the macros available globally. Again Excel seems to
differ
on this point. I am aware that I can make Excel open all files in a
specified
folder on startup, but I don't really think that is the way to do what I
want.
Any suggestions are welcome.

Regards
Morten Frederiksen

 

[Greg Koppel]

Put it on a toolbar, which you can then attach to the workbook. You should
create Auto_open and Auto_close macros to assign/unassign the macros when
you open and close the workbook. Otherwise you end up with associations that
are problematic if you ever change any of the code.

Regards, Greg