I have created a custom button and placed it on the toolbar. Is there a way
to assign a Macro to it, without the macro being workbook specific? Thanks.
Save the macro to your Personal macros workbook. Once this workbook is
created it opens as a hidden workbook in the background. Or, if you prefer,
save the workbook the macro is in as an XLA Add-in file, and then toggle it
on/off from the Tools/Add Ins menu option.

Signature
Kevin Backmann
> I have created a custom button and placed it on the toolbar. Is there a way
> to assign a Macro to it, without the macro being workbook specific? Thanks.