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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent insert/delete rows - sheet code
Select menu item Tools - Protection - Protect Sheet. Check the boxes against those things you want the user to be able to do and leave the others unchecked. Enter a password. (You will be prompted to enter it again.) WARNING: Don't forget the password. -- Regards, OssieMac "Hennie Neuhoff" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent insert/delete rows - sheet code
Forgot to say that before implementing my previous suggestion you may want to select all cells that you want the user to be able to edit then select menu item Format - Cells - Protection tab and uncheck Locked. -- Regards, OssieMac |
Reply |
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 |