using excel 2003 on a mac
I wrote a macro and it works, the problem is that I saved it to the workbook, and it needs to be able to be used in other workbooks.
1) will adding a shortcut icon to the toolbar or adding the macro to a menu make it available to use in other files without having the workbook it was created in open?
2) I managed to add the macro to a menu, but I labelled it wrong is there a way to either remove it from the menu or to rename it?
I wrote a macro and it works, the problem is that I saved it to the workbook, and it needs to be able to be used in other workbooks.
1) will adding a shortcut icon to the toolbar or adding the macro to a menu make it available to use in other files without having the workbook it was created in open?
2) I managed to add the macro to a menu, but I labelled it wrong is there a way to either remove it from the menu or to rename it?