| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Insert Row Event?
Excel 2000
Is there any worsheet event that fires when the user inserts row(s)? Can't seem to find one. My only problem is that if the user inserts rows I need to run the Application.Undo statement so that the insert is reversed. Thanks in advance for your help ... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Insert Row Event?
Would it not be better to use Protect to stop the user from inserting rows.
Not sure what options there are in xl2000 but in xl2002 "Insert Rows' can be stopped with Protect. Look up Protect in Help for more info. Regards, OssieMac "WCM" wrote: Excel 2000 Is there any worsheet event that fires when the user inserts row(s)? Can't seem to find one. My only problem is that if the user inserts rows I need to run the Application.Undo statement so that the insert is reversed. Thanks in advance for your help ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Row (Event Classification) | Excel Discussion (Misc queries) | |||
| How to Capture insert row event in Excel using VBA | Excel Programming | |||
| catch event insert a row or delete a row | Excel Programming | |||
| How to insert a breakpoint and run the Workbook_Open event ?? | Excel Programming | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Linear Mode
