Copying Macro Code from one Sheet to another

[sandeeppyadav]

How do I copy a macro code from one sheet to another which itself is created by a macro code.

My one macro is creating a sheet and for that it is using a raw or draft sheet, but the main problem here is that the VBA Code for Userform popup on selection of some specified cells is not copied from that raw or draft sheet to the new worksheet and hence it doesn't pop up userform there.

Please help me to rectify this problem.

Regards

Sandy

 

[VoG]

This may help you http://www.cpearson.com/excel/VBE.aspx

 

[Andrew Poulsom]

Welcome to MrExcel.

If you copy a worksheet the code in its module is also copied.