Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Rows form Protected Sheet
Hi
I have a worksheet whihc has a combination of protected and unprotected columns of data. I want to enable users to delete rows even when the worksheet is protected, and I have selected "Edit Objects" and "Edit Scenario's (amongst other options) in the Protect Sheet window, yet when I want to delete rows form the worksheet I get a message saying that some of my cells are protected and I firts need to unprotect them before I can delete rows. Is there a way around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Rows form Protected Sheet
How about unlocking all the cells in each of the rows that should be able to be
deleted? If you can't do that, you could provide a macro that unprotects the worksheet, does the delete, and then reprotects the worksheet. WildWill wrote: Hi I have a worksheet whihc has a combination of protected and unprotected columns of data. I want to enable users to delete rows even when the worksheet is protected, and I have selected "Edit Objects" and "Edit Scenario's (amongst other options) in the Protect Sheet window, yet when I want to delete rows form the worksheet I get a message saying that some of my cells are protected and I firts need to unprotect them before I can delete rows. Is there a way around this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
Deleting Rows Containing Protected Cells | Excel Worksheet Functions | |||
Add tab access to check boxes in a protected Excel sheet form. | Excel Discussion (Misc queries) | |||
deleting the blank rows from the sheet | Excel Worksheet Functions | |||
Help !!! Deleting rows in protected document ?!? | Excel Discussion (Misc queries) |