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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to create a macro in excel to use in different workbookks? (https://www.excelbanter.com/excel-worksheet-functions/179903-how-create-macro-excel-use-different-workbookks.html)

Emma

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

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

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

Can you post your code and maybe someone can help.
--
HTH,
Barb Reinhardt

"Emma" wrote:

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?

All times are GMT +1. The time now is 08:00 PM.