It sounds like you're assigning the macro to a button/object/icon on a toolbar.
If that's the case, you may want to reassign the macro in code to the workbook
that owns the macro.
If you used a button from the Forms toolbar, a simple change may work for you.
Delete that button and use a commandbutton from the control toolbox toolbar.
Then double click on that commandbutton and have that code call your macro:
Private Sub CommandButton1_Click()
If you have trouble, you may want to post back with more details.