There is a workbook open event in which any code can be triggered when the
workbook is opened.

Right click on the Excel icon next to the File menu - View code - Select
Workbook in the drop down menu containing General.

--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html

wrote in message
oups.com...
Hi, is there some macro command in Excel VB with is triggered when a
given worksheet is opened? If so what's the syntax? Many thanks in
advance.