Now I have another question...
The macro won't work for one of my workbooks. The workbook collects
data from another workbook (i.e. =[Workbook1.xls]Sheet1! type) and I
ALSO want this workbook to have the macro work the same way...but it
won't.

How do I make this macro work for this workbook?


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=389185