SheetActivate

[Guest]

in microsoft excel 2000 when I add a raw the event SheetActivate is not throw.
It works fine on excel 2003
Is it normal ?

Then how can I know i someone has added a raw in excel 2000 ?

thx

 

[Guest]

The activate event only triggers when the sheet is activated

You need to select/use the Worksheet_Change event

bac

Please rate this post below->Thanx

 

[Guest]

ho thx for your answer, of course i wanted to say "Worksheet_Change" i have
done a mistake.
and this event doesn't work very well in excel2000
when you add column or raw, the event is not called.