macro to all workbooks
 

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

macro 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.

In article
,
wrote:

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

macro to all workbooks
 

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

On Wed, 27 Feb 2008 04:01:41 -0800 (PST), wrote:

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