What first - sheet_change, calculate,selection, etc.
It shouldn't unless Sheet2 and Sheet3 are linked so that a change in
Sheet3 causes a calculation event in sheet2 (e.g., a cell in Sheet2 has
=Sheet3!A1 as its formula).
In article ,
"Tom Rudski" wrote:
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.
|