Workbook Event

[tahrenholtz]

I'm trying to get and event that runs after a Worksheet is Activated and after the Worksheet is updated. In other work when I go to the new worksheet I need it to update before the macro runs rather than before the worksheet updates itself. Any one have an idea to get this to work?

[TMS]

A worksheet activate event handler only does what you ask it to when the sheet is activated. There's no updating unless your code does it. The worksheet change event handler fires when you update (make changes to) the worksheet.