Thanks again.
Tried both and no luck. I'm sure there is a way...RiGHT?
"Bearacade" wrote:
You want it to return to the spreadsheet/worksheet that it was at?
try taking out Windows("Menu_list.xls").Activate
or change it to Windows("Name of the original xls".Activate
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553757