Sheet Insert Row Event?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ...
 
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
 
The sheet contains a pivot table. Using 'Protect' will disable the pivot
table as well. So, in this case, that option won't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Insert Row Event 2
Insert rows in grouped sheets 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Keeping formulas on an insert 1
Mid column sum formulas with varied ranges to sum 17
How to insert a row into Excel Sheet? 1
insert 3 rows between data 3

Back
Top