Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows while sheet protected
I have a worksheet protected, cells locked, and password protected. Other
users have access to this file and need to be able to insert rows and delete rows. However, they are having trouble deleting rows. Is there a way to fix this or is it more trouble then it is worth? I am trying to protect my formulas I have worked so hard on. Any help will be useful |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows while sheet protected
In xl2002+, you can let the user insert/delete rows on a protected worksheet.
Under Tools|Protection|protect sheet (xl2003 menus), there's a couple of options that can be checked. loulou wrote: I have a worksheet protected, cells locked, and password protected. Other users have access to this file and need to be able to insert rows and delete rows. However, they are having trouble deleting rows. Is there a way to fix this or is it more trouble then it is worth? I am trying to protect my formulas I have worked so hard on. Any help will be useful -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows while sheet protected
To be more specific, we have xp. We can protect the sheet and check the boxes
allowing all users to insert and delete rows however, they can insert but can't delete. "Dave Peterson" wrote: In xl2002+, you can let the user insert/delete rows on a protected worksheet. Under Tools|Protection|protect sheet (xl2003 menus), there's a couple of options that can be checked. loulou wrote: I have a worksheet protected, cells locked, and password protected. Other users have access to this file and need to be able to insert rows and delete rows. However, they are having trouble deleting rows. Is there a way to fix this or is it more trouble then it is worth? I am trying to protect my formulas I have worked so hard on. Any help will be useful -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete rows while sheet protected
That is correct.
You can only delete a row in which all cells are unlocked. Insert doesn't care about locked cells so you can insert rows. You must unprotect the sheet, delete the selected rows then re-protect. Sub delete_rows() ActiveSheet.Unprotect Password:="yourpassword" Selection.EntireRow.Delete ActiveSheet.Protect Password:="jyourpassword" End Sub Give your users a button for deleting rows. Gord Dibben MS Excel MVP On Thu, 7 Aug 2008 10:55:06 -0700, loulou wrote: To be more specific, we have xp. We can protect the sheet and check the boxes allowing all users to insert and delete rows however, they can insert but can't delete. "Dave Peterson" wrote: In xl2002+, you can let the user insert/delete rows on a protected worksheet. Under Tools|Protection|protect sheet (xl2003 menus), there's a couple of options that can be checked. loulou wrote: I have a worksheet protected, cells locked, and password protected. Other users have access to this file and need to be able to insert rows and delete rows. However, they are having trouble deleting rows. Is there a way to fix this or is it more trouble then it is worth? I am trying to protect my formulas I have worked so hard on. Any help will be useful -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows in a protected worksheet | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
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) |