Catch insert line event

[Franck]

Hi, is it possible to catch the insert/delete line event ?

thks for help

 

[Sunil Jayakumar]

You could try:

Rows("1:3").Select
Selection.Delete Shift:=xlUp

Rows("1:3").Select
Selection.Insert Shift:=xlDown


Hope this helps

Sunil Jayakumar

Hi, is it possible to catch the insert/delete line event ?

thks for help

www.ayyoo.com/credit-cards.html

 

[Sunil Jayakumar]

Hi Franck,

I just re-read your post, and are you trying to block users from
inserting/deleting rows from a template?

I find it useful to:

a) stick a 1 in cell IV:65536 - this will give them a "Cannot move non-blank
cells off the worksheet" error
b) using the worksheet change event, check if cell IV65536 is blank (deleted
rows), and kick off a msgbox and an undo procedure.

Hope this helps

Sunil Jayakumar

Hi, is it possible to catch the insert/delete line event ?

thks for help

www.ayyoo.com/credit-cards.html