Hi folks - I'm trying to assign a small macro to run from
a new menu item in Excel 97. I've create an xla add-in
with the macro in it and added the new menu item via
Customize Toolbar-Commands-Macros-Custom Menu Item.

When I go to the 'Assign Macro' option for the new menu
item, my macro is not listed. I can type it in and it
works fine when I've manually loaded the xla. I then copy
my xla to a network location and set that Default File
Location to this path. When I open Excel, the new menu
option is there ok, but I get the and error saying 'The
macro 'test' cannot be found'.

It's got me stumped unfortunately. I can't find anything
in Excel Help or the MS website, so any help would be much
appreciated.

Thanks.