Events for listobject

[sai]

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

 

[John Scott]

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

Sai,

I have a similar project where I have to prevent the user from inserting
a column in a list, though I did want them to be able to insert rows. I
unlocked all the cells in the sheet, and then protected it - the
worksheet protection methods allow you to specify whether a user is able
to insert rows or columns (independent of each other). With all the
cells unlocked, the user can still edit cells, sort the list, etc.

John Scott