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.
--
Kevin Backmann


"Kou Vang" wrote:

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.