workbook open()

  • Thread starter Thread starter John
  • Start date Start date
J

John

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.
 
Back
Top