I have a workbook, named workbook("base"), with a specific worksheet in
it, and I perform the following method:

worksheet(1).copy

I then want to be able to copy the userform "UsrFrm1" from
workbook("base") into the new workbook that is created when i do
"worksheet(1).copy"

do i need to use objects in the VBE model, or is it easier than that?

thanks in advance

Jason.

cheers Norman

but what are the lines of code that'll programmatically do this for me?

Regards
Jason

Check this link 'Programming To The Visual Basic Editor '
(http://www.cpearson.com/excel/vbe.htm)


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=373653