Hello
I am using this macro via an activex checkbox. It works ok but the screen flickers whenever it is selected or deselected. By hiding a row I would have expected the rows below to move up but the issue here is that they seem to jump up but then jump back to the starting point.
I have tried using Application.ScreenUpdating but this doesn't make any difference.
Is there a way to stop this happening?
Thank you
I am using this macro via an activex checkbox. It works ok but the screen flickers whenever it is selected or deselected. By hiding a row I would have expected the rows below to move up but the issue here is that they seem to jump up but then jump back to the starting point.
VBA Code:
Private Sub CheckBox2_Click()
If CheckBox2 = False Then
[11:11].EntireRow.Hidden = True
Else:
[11:11].EntireRow.Hidden = False
End If
End Sub
I have tried using Application.ScreenUpdating but this doesn't make any difference.
Is there a way to stop this happening?
Thank you