Try the Worksheet_Change event. See http://www.cpearson.com/excel/events.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Zamdrist" wrote in message
oups.com...
I'm attempting to trigger some VBA code and tried both the Calculate &
Activate events of both the Workbook & Worksheet objects, however
neither seem to fire off.

I can get Activate to trigger by switching sheets, but that doesn't
work for me as I am relying on ActiveSheet.

My XLT has a database query tied to it also, but apparently that
doesn't trigger th Calculate event.

What would be the best way to automatically trigger my code after the
Workbook is open and after or while the underlying data is being
retrieved?

Thanks