Macro:
Sub ViewConditionalFormatting()
'
' ViewConditionalFormatting Macro
'
Range("G2").Select
If ActiveCell = True Then
ActiveCell = False
Else
ActiveCell = True
End If
'
End Sub
I have a conditional formatting set determined by the value of cell G2 being TRUE/FALSE.
I added a button to the quick toolbar using that macro, which works wonderfully. But, when I run it, the sheet scrolls up to cell G2. How can I eliminate that so it stays where I was? Thanks
Bookmarks