PC Review


Reply
Thread Tools Rate Thread

How do I make a copy of a macro?

 
 
jjnotme
Guest
Posts: n/a
 
      8th Mar 2008
Hi:
Please tell me how to make a copy of a macro in excel 2003. I need to
make copies of several macros and I just don't know how.

Thank you.

Carol.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      8th Mar 2008
Not sure what you mean.

Select the text and copy?
Right click the module in the project explorer window and choose Export?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jjnotme" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi:
> Please tell me how to make a copy of a macro in excel 2003. I need to
> make copies of several macros and I just don't know how.
>
> Thank you.
>
> Carol.



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      8th Mar 2008
It would depend upon what you want to do with the copied macros.

Could you give us a hint?

To copy a macro go to Tools>Macro>Macros.

Select a macro bty name and "Edit"

Copy the macro and do something with it.


Gord Dibben MS Excel MVP

On Sat, 08 Mar 2008 19:06:27 GMT, jjnotme <(E-Mail Removed)> wrote:

>Hi:
>Please tell me how to make a copy of a macro in excel 2003. I need to
>make copies of several macros and I just don't know how.
>
>Thank you.
>
>Carol.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you make a copy+paste macro in access? chris.madmanger@virgin.net Microsoft Access Macros 1 29th Mar 2008 02:17 AM
Copy hidden sheet and then make copy visible HELP? quidsin@gmail.com Microsoft Excel Programming 5 7th Aug 2007 02:31 PM
How to make a copy of a macro toolbar icon Craig Microsoft Word New Users 6 14th Jul 2005 01:32 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Microsoft Excel Programming 1 15th Oct 2004 01:16 PM
how to make copy of 1 appointment when you make it! chris petersen Microsoft Outlook Calendar 1 19th Apr 2004 08:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:44 AM.