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
|