Hi to all,
I have 3 columns in data range A1:C15
I want that when a value in cell in column A is 0 ( zero) then corresponding cell in column C is lock and format is changed to no color (Selection.Interior.ColorIndex = xlNone, Selection.Locked = True, Selection.FormulaHidden = True )
Otherwise , If cell value in column A is another value then (Selection.Interior.ColorIndex = 2, Selection.Locked = False, and Selection.FormulaHidden = True)
This will be trigger with sheet activate
See Exemple attached
Please save my life
Merci Beaucoup
Marc
Excel 2003
I have 3 columns in data range A1:C15
I want that when a value in cell in column A is 0 ( zero) then corresponding cell in column C is lock and format is changed to no color (Selection.Interior.ColorIndex = xlNone, Selection.Locked = True, Selection.FormulaHidden = True )
Otherwise , If cell value in column A is another value then (Selection.Interior.ColorIndex = 2, Selection.Locked = False, and Selection.FormulaHidden = True)
This will be trigger with sheet activate
See Exemple attached
Please save my life
Merci Beaucoup
Marc
Excel 2003