Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events for listobject
sai wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListObject object formatting | Excel Discussion (Misc queries) | |||
ListObject in Excel 2000 ? | Excel Discussion (Misc queries) | |||
LISTOBJECT question | Excel Programming | |||
Need some events... | Excel Programming | |||
listobject ... Excel2003 | Excel Programming |