Track changes across multiple worksheets
 

I'm am trying to track hanges across multiple worksheets in the same
workbook. Excel will only allow me to do this for one worksheet in the book.
I have tried the various ctrl and shift options. Is this possible at all?

It's possible with VBA, the workbook object has an event called SheetChange.
Every time a change happens in any sheet in the workbook this event is
triggered.

"Charris" wrote:

I'm am trying to track hanges across multiple worksheets in the same
workbook. Excel will only allow me to do this for one worksheet in the book.
I have tried the various ctrl and shift options. Is this possible at all?