Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Rows depending on Values in Particular Columns
Hello All,
I am using Excel 2003 and have a problem: I have a worksheet where I maintain my Annual Maintenance Records (AMC). The details are as follows: Worksheet Name: AMC 2005 Range Name: Database (Dynamic) Col G: Cell Values = (Data Validation to allow only) Closed or Blank Col AA: Cell Values = (Data Validation to allow only) Invoice, Cash, Check. I wish to have a macro solution where it should search for Col G and Col AA values...if both are filled with Closed and Cash/Invoice/Check respectively...then that particular row should be protected .. what I mean not editable.... where both Col G = Closed and Col AA is either of the three values viz.. Invoice, Cash or Check Any help would be appreciated. TIA Ashish Kumar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values, x rows deep, depending on a criterion | Excel Worksheet Functions | |||
Protect Hidden Columns and Rows | Excel Discussion (Misc queries) | |||
counting rows depending on 2 selective values | Excel Discussion (Misc queries) | |||
Insert rows in depending on criteria in variable columns | Excel Programming | |||
deleting the rows depending on the result of a condition involving two columns. | Excel Programming |