How to create a macro in excel to use in different workbookks?

[Emma]

Need to create macro in excel to use in different workbooks and it seems that
when I recorded the macro it was only looking at the current workbook. How
do I create it so that it run on all workbooks?

 

[Barb Reinhardt]

Can you post your code and maybe someone can help.