You can put macros in your Personal.xls workbook or in an add-in and
they will be available to all workbooks.

In article
,
wrote:

is there possible to apply the macro to all workbooks in excel