Thanks this worked!!....But what should I put in the code to have it
auto-return the the main page (from where it was opened)?

"Bearacade" wrote:


You have to call the sub..

and I don't know if auto.open would be the right syntax...

Try:

Workbooks.Open Filename:= "Menu_list.xls"
Windows("Menu_list.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