Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete record(s) in other cells based on value of one cell.
What I have is a protected sheet, where all columns except for 3 are
protected. I cannot delete the entire row with protection turned on. So, what I need is to be able to delete the value in these three columns, only when the value in column A is "d". Any clues? Protection must remain on, users are using this spreadsheet and I cannot allow them to have access to the formulas in these other columns. Help...Micheal |
#2
|
|||
|
|||
Provide a macro that unprotects the worksheet, does the work and reprotects the
worksheet is one way around the problem. MPope wrote: What I have is a protected sheet, where all columns except for 3 are protected. I cannot delete the entire row with protection turned on. So, what I need is to be able to delete the value in these three columns, only when the value in column A is "d". Any clues? Protection must remain on, users are using this spreadsheet and I cannot allow them to have access to the formulas in these other columns. Help...Micheal -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
locking cells based on results at runtime | Excel Worksheet Functions | |||
copying cells based on criteria | Excel Worksheet Functions | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |