trying to move macro from personal workbook w/o deleting

[WGGMKG]

I'm trying to change the location a macro is saved in. when created, it was saved in the personal macro workbook, issue is when spreadsheet is opened by another user in the network, the macro is available.
i need to save the macro with the workbook.

can the macro location be changed the be saved in the workbook?

 

[shajueasow]

Try this way.
Open the workbook in which you need the macro and hit ALT+F11 to bring up the VBE. Use View>Project Explorer (shortcut CTRL+R) to see your opened workbook and Personal.xls on the left hand pane. Click and drag the macro in personal.xls to your needed workbook in the left hand pane itself.
HTH