Run macro on insert now row

[savvito]

Hello,

I want to run a macro every time the user inserts a new row.
I searched for insert row event but I cannot find anything. Can anyone help?


thank you!

[shg]

There's a discussion about this by some Excel heavyweights at http://www.dailydoseofexcel.com/arch...-deleted-rows/

[savvito]

thanks for the link, after reading it I have a bit better understaning but still I cannot do it. if I find the solution I will post it here

[stanleydgromjr]

savvito,

See:

Worksheet Insert Row Event - Tom Urtis
http://www.mrexcel.com/archive2/72100/83615.htm