| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid deleting of rows
Hi,
I have a problem where I would like some help on. I would like that the users can't delete or insert rows. They should however still be able to Hide or Unhide rows. They should also still be able to change the data in the cells of the rows. Is there anybody with a good solution? Thank you Wim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to avoid deleting of rows
"2foot" wrote: Hi, I have a problem where I would like some help on. I would like that the users can't delete or insert rows. They should however still be able to Hide or Unhide rows. They should also still be able to change the data in the cells of the rows. Is there anybody with a good solution? Thank you Wim Hi, ToolsProtectionProtect Sheet. Tick every box apart from Delete Rows and Insert Rows. You need to enter a password. HTH |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to avoid deleting of rows
"2foot" wrote in message oups.com... Hi, I have a problem where I would like some help on. I would like that the users can't delete or insert rows. They should however still be able to Hide or Unhide rows. They should also still be able to change the data in the cells of the rows. Is there anybody with a good solution? Thank you Wim Depends on your Excel version. When you protect a sheet in Excel2003, you can specify, that deleting and inserting of rows are forbidden, but that other changes are allowed. Joerg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows automatically to avoid overwriting | Excel Discussion (Misc queries) | |||
| How to avoid deleteing certain rows? | Excel Programming | |||
| Avoid user to access first two rows in a sheet | Excel Programming | |||
| Avoid Deleting a Shared Workbook using VBA | Excel Programming | |||
| How to Avoid Printing Blank Rows | Excel Programming | |||
Hybrid Mode
