Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent insert/delete rows - sheet code
Hi Guys Excel 2003 I want to prevent the user from inserting/delete rows on certain sheets in the workbook. On this site I got an idea to display a message [Worksheet_Activate] which works fine, but that's not really what I want. The problem is these messages appears when I run other code like "Sort sheets by name" etc.. I guess the " Worksheet_Activate" should be replaced by something like Worksheet_change. I don't know how to do this. As always, any assistance will be appreciated. -- HJN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Insert Row and Delete Row from Menu | Excel Discussion (Misc queries) | |||
Prevent worksheet Rows to Delete. | Excel Programming | |||
prevent row insert in a range of rows | Excel Programming | |||
how do i prevent a #REF! error when i delete non adjacent rows? | Excel Worksheet Functions | |||
Prevent sheet add or delete | Excel Programming |