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

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
>

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
> >

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
> > >

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
> > > >