Hi,
I am trying to convert my workbook to an add in. the workbook has
worksheets that are required for it to function correctly. I am havin
great difficulty in getting each of the worksheets to copy over to th
opening workbook when installed as an add in.

tried commands such as
Workbooks("Mega.xla").Sheets(1).Copy
for each sheet but this copies each sheet to a new workbook, I wan
each sheet copied to a new workbook sheet, can anyone help?

thank

--
cmpcwil
-----------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...fo&userid=3341
View this thread: http://www.excelforum.com/showthread.php?threadid=54032