Hi,
move your code from Auto_open routine to Workbook_Open(). Auto_open i
performed only if the workbook was opened manually, Workbook_Open i
performed always (Workbook opened via Task Scheduler or VBA).
Jare

--
Jare
-----------------------------------------------------------------------
Jarek's Profile: http://www.excelforum.com/member.php...info&userid=96
View this thread: http://www.excelforum.com/showthread.php?threadid=26211