Undo!!
Yes, for manual changes, you can undo. Run a macro and,... you're screwed.
Anyhow, to make up for it, they do let you create a macro to toggle the highlight colour of a cell :
Sub toggle_hilite()
With Selection.Interior
If .Color = 16777215 Then ' 25 bits all 1
.Color = 65535
Else
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End If
End With
End Sub
No comments:
Post a Comment