Thanks JE that was a good link and I'll download Chip's example event code.
Another quick question is I have worksheet_calculate code in Sheet2. When I
change a cell in Sheet3 why does Sheet2 "calculate' code execute. I thought
each sheet was it's own code. sheet 3 would not affect Sheet2.
The Sheet2 SUB is coded Private.
TIA

"JE McGimpsey" wrote:

See the "Order of Event Procedures" section of

http://cpearson.com/excel/events.htm

In article ,
"Tom Rudski" <Tom wrote:

Whose on First!!!
In Sheets VBA windows you can select all of the different code options (i.e.
change, calculate, selection, etc.)
What code section (SUB)is executed first?
Why does it go in circles. At the end one SUB the execution jumps into the
middle of another SUB?
Any ideas haven't seen anything written on this before.

TIA