I need to detect when a user inserts or deletes a row. I can sense a change
in the "selection_Change" triggered macro - and can see that a selection is 1
(or more) rows by 256 columns (so the entire row or rows) -
But I can't figure out to tell that the user is deleting or inserting a row.

I can disable these functions via protect and give him separate macros for
inserting/deleting rows - but it would be easier for the users if they could
just right click like they are used to.

I was thinking I could just modify the drop down menu and also replace the
insert/delete row built-in functions - but it would be better if I could just
sense when a user was using these functions in the trigger macro.

Any suggestions?

Try this:
http://www.dailydoseofexcel.com/arch...-deleted-rows/

NickHK

"Thrash" <(E-Mail Removed)> wrote in message
news:2BD85342-E1F4-4C5E-8D78-(E-Mail Removed)...
> I need to detect when a user inserts or deletes a row. I can sense a
change
> in the "selection_Change" triggered macro - and can see that a selection
is 1
> (or more) rows by 256 columns (so the entire row or rows) -
> But I can't figure out to tell that the user is deleting or inserting a
row.
>
> I can disable these functions via protect and give him separate macros for
> inserting/deleting rows - but it would be easier for the users if they
could
> just right click like they are used to.
>
> I was thinking I could just modify the drop down menu and also replace the
> insert/delete row built-in functions - but it would be better if I could
just
> sense when a user was using these functions in the trigger macro.
>
> Any suggestions?