|In the VBE you can turn off the highlighting under: |
Tools...Options...Editor Format Tab...Execution Point Text...Background
Another test besides F8 would be place a syntax error in some code and then try to run it.
Put this in a sheet module and select any cell. When the Compile Error pops up, click OK and the first line (Private Sub...) should be highlighted. If that works but F8 still doesn't highlight the Execution Point, then I'll be as confused as you are.
I assume you've restarted your computer since this began, right?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
iff target =4 then end sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.