J JE McGimpsey Feb 27, 2008 #2 You can put macros in your Personal.xls workbook or in an add-in and they will be available to all workbooks.
You can put macros in your Personal.xls workbook or in an add-in and they will be available to all workbooks.
G Gord Dibben Feb 27, 2008 #3 Two ways to look at this question. 1. You want one macro to do something to every Excel workbook in a folder. See Ron de Bruin's site for copy/paste/merge examples. http://www.rondebruin.nl/tips.htm 2. You want a macro to be available to run on any workbook that is open. See JE's reply. Gord Dibben MS Excel MVP
Two ways to look at this question. 1. You want one macro to do something to every Excel workbook in a folder. See Ron de Bruin's site for copy/paste/merge examples. http://www.rondebruin.nl/tips.htm 2. You want a macro to be available to run on any workbook that is open. See JE's reply. Gord Dibben MS Excel MVP
