Call Macro in current workbook via custom menu

Hi,

We have a spreadsheet that is used by many people across many locations. As this sheet has grown we have needed to free up some space. And so I have desgined a custom menu that all users will have installed in Excel that will run macros that relate to the spreadsheet.

The macro's stored in the spreadsheet are quite lengthy, so I didn't want to copy the code into the custome menu. I wanted to call them from the menu like so:

Please Login or Register  to view this content.

However I'm getting an error to say that it cannot find the Macro, could somebody tell me what I'm doing wrong?

Many Thanks

Macro1

The error perhaps occurs because the file in which the code is parked is closed. If you do this every time you have to keep open that file. I suggest you park the code in personal.xls file . Your submenu should assign this macro in personal.xls file. This file always opens whenever any excel file is opened but remains hidden.

Thanks Venkat1962,

I think the problem with that is that everytime I make an update to the template, the code would need to be recopied into all of the users personal.xla file. The reason i want it to call stright from the template is so that if any changes are made the user will always have the latest version.

I just can't get it to pull through though!!!

Thanks again