ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macros (https://www.excelbanter.com/excel-discussion-misc-queries/160465-macros.html)

Chi

Macros
 
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


Gary''s Student

Macros
 
You can use copy/paste or export/import to get a copy to the new workbook.
--
Gary''s Student - gsnu200748


"Chi" wrote:

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


Gord Dibben

Macros
 
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

On Tue, 2 Oct 2007 06:38:01 -0700, Chi wrote:

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




All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com