View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sai sai is offline
external usenet poster
 
Posts: 10
Default Events for listobject

Hi,

Is there a way I can trap when the user tries to add a new row to a
list object? I want to prevent the user from adding a new row. The
workbook change event is fired after the user has already entered
information into a cell and the insertrowrange has already changed. I
want to know when the user tries to enter information into the
insertrow and then prevent the user.

Sai