View Single Post
  #3   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi

No, impossible. This is a limitation by design. A macro could change the
cell itself, the sheet, excel, and therefore mess up the original logic and
the order of calculations.

But Excel has several "calculate" events that you might use to create a
simiular effect.

HTH. Best wishes Harald

"filo666" skrev i melding
...
1. There is some way to make that excel, starting from a conditional
structure in a cell, execute automatically a macro???

Something like this:
A B
1
2 1 =if(A2=1,macro1(),macro2())