Just some supplementary information:
A useful overview of events is available at Chip Pearon's site:
http://www.cpearson.com/excel/events.htm
and application level events
http://www.cpearson.com/excel/appevent.htm
--
Regards,
Tom Ogilvy
"Damon Longworth" wrote in message
...
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.