Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting rows with locked cells
Hello,
I'm trying to find a way to overcome a "feature" I've dicovered with Excel protection. If protection is enabled, with the "delete row" checkbox active, the row cannot be deleted if there are locked cells in the row. Is there a way to defeat this "feature"? Cheers, Paul excel beginner -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address |
#2
|
|||
|
|||
Unlock those cells to start
or unprotect the worksheet, do the deletion and then reprotect the worksheet? Paul Moore wrote: Hello, I'm trying to find a way to overcome a "feature" I've dicovered with Excel protection. If protection is enabled, with the "delete row" checkbox active, the row cannot be deleted if there are locked cells in the row. Is there a way to defeat this "feature"? Cheers, Paul excel beginner -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address -- Dave Peterson |
#3
|
|||
|
|||
Dave, I don't want to unlock those cells, they contain formulas that I'm
afraid I might accidentally delete. It would be nice if I (or my users) didn't have to unprotect the sheet each time. Is there any other solution? Regards, Paul -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address "Dave Peterson" wrote in message ... Unlock those cells to start or unprotect the worksheet, do the deletion and then reprotect the worksheet? Paul Moore wrote: Hello, I'm trying to find a way to overcome a "feature" I've dicovered with Excel protection. If protection is enabled, with the "delete row" checkbox active, the row cannot be deleted if there are locked cells in the row. Is there a way to defeat this "feature"? Cheers, Paul excel beginner -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address -- Dave Peterson |
#4
|
|||
|
|||
Give the users a macro that would:
unprotect the worksheet sort your data reprotect the worksheet. Record one when you do it the first time. If you have trouble making it work, post back what you've got. You could even plop a button from the forms toolbar onto that worksheet. Assign your sort macro to it and the users might even be happier since they have less work to do! Paul Moore wrote: Dave, I don't want to unlock those cells, they contain formulas that I'm afraid I might accidentally delete. It would be nice if I (or my users) didn't have to unprotect the sheet each time. Is there any other solution? Regards, Paul -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address "Dave Peterson" wrote in message ... Unlock those cells to start or unprotect the worksheet, do the deletion and then reprotect the worksheet? Paul Moore wrote: Hello, I'm trying to find a way to overcome a "feature" I've dicovered with Excel protection. If protection is enabled, with the "delete row" checkbox active, the row cannot be deleted if there are locked cells in the row. Is there a way to defeat this "feature"? Cheers, Paul excel beginner -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge two cells without deleting data from the cell? | Excel Discussion (Misc queries) | |||
Selecting rows from cells | Excel Discussion (Misc queries) | |||
How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Can I hide locked cells? | Excel Worksheet Functions |