Hi all,
I am trying to process a function when a workbook open.
I put my code in Workbook.Open and Workbook.Activate
event, but it only works in a .xls file but doesn't
in .xlt file.

Does any one know how to process a function when a
template file is opened. THanks for any
answer/suggestion.

John.

Use the 'Window' object of the Excel App, and track the
events of that object. A lot more work but yoy will be
able to track multiple windows of the same book,
template, chart etc.


-----Original Message-----
Hi all,
I am trying to process a function when a workbook open.
I put my code in Workbook.Open and Workbook.Activate
event, but it only works in a .xls file but doesn't
in .xlt file.

Does any one know how to process a function when a
template file is opened. THanks for any
answer/suggestion.

John.
.