Copy selected macro(s) to a different workbook
 

Hello

I know that a whole module can be exported/imported into a different
workbook, but is it possible to select macros from a module and copy them to
a different workbook.

Thanks

Copy selected macro(s) to a different workbook
 

hi
yes. high light all or any part of the code then copy. in this respect,
it's not unlike coping and pasting in notepad. just be carefull where you
paste.

Regards
FSt1

"Cresta" wrote:

Hello

I know that a whole module can be exported/imported into a different
workbook, but is it possible to select macros from a module and copy them to
a different workbook.

Thanks

Copy selected macro(s) to a different workbook
 

Sorry I should have been a bit more specific. The copying is to be done by a
macro.

"FSt1" wrote:

hi
yes. high light all or any part of the code then copy. in this respect,
it's not unlike coping and pasting in notepad. just be carefull where you
paste.

Regards
FSt1

"Cresta" wrote:

Hello

I know that a whole module can be exported/imported into a different
workbook, but is it possible to select macros from a module and copy them to
a different workbook.

Thanks

Copy selected macro(s) to a different workbook
 

hi
opps.
see this site
http://cpearson.com/excel/vbe.aspx

regards
FSt1

"Cresta" wrote:

Sorry I should have been a bit more specific. The copying is to be done by a
macro.

"FSt1" wrote:

hi
yes. high light all or any part of the code then copy. in this respect,
it's not unlike coping and pasting in notepad. just be carefull where you
paste.

Regards
FSt1

"Cresta" wrote:

Hello

I know that a whole module can be exported/imported into a different
workbook, but is it possible to select macros from a module and copy them to
a different workbook.

Thanks

Copy selected macro(s) to a different workbook
 

Thanks FSt1, that looks like it will do the trick.

"FSt1" wrote:

hi
opps.
see this site
http://cpearson.com/excel/vbe.aspx

regards
FSt1

"Cresta" wrote:

Sorry I should have been a bit more specific. The copying is to be done by a
macro.

"FSt1" wrote:

hi
yes. high light all or any part of the code then copy. in this respect,
it's not unlike coping and pasting in notepad. just be carefull where you
paste.

Regards
FSt1

"Cresta" wrote:

Hello

I know that a whole module can be exported/imported into a different
workbook, but is it possible to select macros from a module and copy them to
a different workbook.

Thanks