Using VB To Copy Code Internally

[nvanfossan01]

Thank You in Advance,

Im imbedding VB in an excel sheet and I would like to use a button to create a new excel sheet, and copy the VB code associated with another sheet to this sheet. Basically is there a way to copy VB code internal to the program.

nvanfossan01@REMOVEnetscape.net

 

[mi1306]

To want copy excel sheet in new sheet?
Has correctly understood?

Miho

 

[johnwm]

Why not put the code in a separate module?

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[HughLerwill]

nvan,

Have you considered using an Excel template containing the vb code.

regards Hugh