Macros

C

Chi

Hi

I have a macro that runs well on the A workbook. I would like to use that
macro for different workbook. Is it possible to do that? Please help

Thanks
Chi
 
G

Gary''s Student

You can use copy/paste or export/import to get a copy to the new workbook.
 
G

Gord Dibben

That is the purpose of Excel's Personal.xls macro workbook.

Record and/or create macros to Personal Macro Workbook and these macros will be
available for all open workbooks.

Personal.xls is stored in your XLSTART folder and opens hidden when Excel is
started up.

For more on Personal.xls see here.............

http://snipurl.com/1kugy


Gord Dibben MS Excel MVP
 
Top