View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.