Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting row delete/insert
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting row delete/insert
Try this:
http://www.dailydoseofexcel.com/arch...-deleted-rows/ NickHK "Thrash" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert name - delete all | Excel Discussion (Misc queries) | |||
Insert and delete rows | Excel Programming | |||
Insert/delete rows | Excel Programming | |||
Row/Column Insert/Delete | Excel Programming | |||
How to detect an insert/delete? | Excel Programming |