I have a very simple piece of code that will divert the selected cell to cell A1 (hidden behind a logo) so that the users will not see the frame of a selected cell, making this tool look less like an Excel file and more like a normal software program. This sub sits in a normal worksheet (not in modules folder or ThisWorkBook part of the VB code).
The problem is that the screen flickers 2-3 times for each click on the worksheet even with the ScreenUpdating value set to False. It behaves exactly the same even if I comment out the statement that turns ScreenUpdating back to True. Does anybody know why? Thank you in advance for your help!
Please see code below:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = False
If ActiveCell.Address <> "A1" Then
' Hide the active cell (for visibal borders) behind the logo
ActiveSheet.Cells(1, 1).Select
End If
Application.ScreenUpdating = True
End Sub
~ M3atball
Bookmarks