Moving Module Code Along with Tab

[Mike H]

Hello guys,

I'm hoping this should be pretty easy.........

I have a sheet that is copied into different workbooks via a macro from a master file, this works fine, however there is a module that runs a few more bits against this sheet.

Can I take the module across to the new workbook along with the sheet via VBA? How do I take say module 3 across to the new workbook at the same time.

Is it possible?

Cheers

Mike

 

[Andrew Poulsom]

Look at the topic 'Copy A Module From One Project To Another' here:

http://www.cpearson.com/Excel/VBE.aspx