Hi
Store your macros into a personnal.xls workbook hide its window, save
and
place this workbook in the Excel Startup folder.
This will allow your macros to be available each time you open Excel.

HTH
Cordially
Pascal


"Susanne" a écrit dans le message de

...

Hi

How do I get a macro to work in different workbooks without having to
copy
it in to every workbook. I have tried to create a button on the
toolbar

but

it does not work.

Susanne