#1   Report Post  
Posted to microsoft.public.excel.misc
Chi Chi is offline
external usenet poster
 
Posts: 69
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
"openinf file..."ENABLE MACROS...DISABLE MACROS" F. Lawrence Kulchar Excel Discussion (Misc queries) 3 September 12th 06 10:33 AM
Fun with Macros! Mr. Smiley Excel Discussion (Misc queries) 2 May 2nd 06 10:04 PM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
what are macros? Afolabi New Users to Excel 7 May 14th 05 12:27 AM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"