SheetActivate
 

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

SheetActivate
 

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



"Arnaud" wrote:

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

SheetActivate
 

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.

"BAC" wrote:

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



"Arnaud" wrote:

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