Belinda
02-06-2009, 03:55 PM
Hello,
I have macro button that will highlight "cells with formulas" with a yellow background color.
How do I modify the macro so that when I click the button again, it will unhighlight the selected cells?
Sub HighlightFormulas
Cells.SpecialCells(xlCellTypeFormulas).Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub
Thank you
I have macro button that will highlight "cells with formulas" with a yellow background color.
How do I modify the macro so that when I click the button again, it will unhighlight the selected cells?
Sub HighlightFormulas
Cells.SpecialCells(xlCellTypeFormulas).Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub
Thank you