there is nothing in your code to cause it to refer to the original workbook.
Set wb = ActiveWorkbook

is used at the top of the code and your references seem to build down from
that - so if the original workbook is not open, it should not be invovled.

How do you run this macro?

--
Regards,
Tom Ogilvy



"Toolman045" wrote:


Don & Tom: Both of you provided great feedback. However, I know I have
not assigned a button to the code and where would I search for the
control?

I am totally lost when you indicate to place the Macro in my personal
xls so the code is avaiable everywhere.

I should tell you that someone else helped me create the code based on
what I needed to be accomplished in the workbook.

Any more help will be appreciated.


--
Toolman045
------------------------------------------------------------------------
Toolman045's Profile: http://www.excelforum.com/member.php...o&userid=35324
View this thread: http://www.excelforum.com/showthread...hreadid=550986