Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Rows in a protected worksheet
I need to be able to delete rows in a protected worksheet.
When I protect the worksheet it gives me the option to be able to allow a user to delete rows - I check that box. However, it will not allow me to delete the rows after I protect it. Can you tell me what I need to do? -- Kathy Connelly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Rows in a protected worksheet
Hi,
The ability to delete rows on a protected sheet relies upon those rows being unlocked. Select the row(s) you want to be able to delete then Format)Cells|Protection remove the locked checkmark Protect your sheet and you can still delete these rows. Mike "Kathy Connelly" wrote: I need to be able to delete rows in a protected worksheet. When I protect the worksheet it gives me the option to be able to allow a user to delete rows - I check that box. However, it will not allow me to delete the rows after I protect it. Can you tell me what I need to do? -- Kathy Connelly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Rows in a protected worksheet
Kathy
You can delete rows only if the entire row is unlocked before protecting the sheet. How will users select which rows to delete? You could write code that would unprotect, insert rows at user's pre-defined selection then re-protect the sheet. Add a button for user to hit after selecting where to insert the rows. Sub insertrows() ActiveSheet.Unprotect Password:="justme" Selection.EntireRow.Delete ActiveSheet.Protect Password:="justme" End Sub Note: when protecting the sheet you must allow users to select locked cells. Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 11:07:05 -0700, Kathy Connelly wrote: I need to be able to delete rows in a protected worksheet. When I protect the worksheet it gives me the option to be able to allow a user to delete rows - I check that box. However, it will not allow me to delete the rows after I protect it. Can you tell me what I need to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Grouped Rows in Protected Worksheet | Excel Discussion (Misc queries) | |||
Add or Delete Rows in Protected worksheets | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
How do I delete rows from a protected worksheet? | Excel Discussion (Misc queries) | |||
How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions |