pawcoyote
04-15-2022, 12:05 PM
Hi,
I thought I had this correct but whenever I select one of my ActiveX Checkboxes to make it active my whole screen Flickers. I put in the Application.ScreenUpdate and that isn't fixing the issue. Thought this would be pretty straight forward. When you check Checkbox, the hidden worksheet shows. When you uncheck the Checkbox, the Worksheet is hidden again. Maybe because it is showing a new worksheet it has to update the screen?
Private Sub INSTALL_Click()
Application.ScreenUpdating = False
On Error Resume Next
ThisWorkbook.Sheets("Install").Visible = INSTALL.Value
Application.ScreenUpdating = True
End Sub
I thought I had this correct but whenever I select one of my ActiveX Checkboxes to make it active my whole screen Flickers. I put in the Application.ScreenUpdate and that isn't fixing the issue. Thought this would be pretty straight forward. When you check Checkbox, the hidden worksheet shows. When you uncheck the Checkbox, the Worksheet is hidden again. Maybe because it is showing a new worksheet it has to update the screen?
Private Sub INSTALL_Click()
Application.ScreenUpdating = False
On Error Resume Next
ThisWorkbook.Sheets("Install").Visible = INSTALL.Value
Application.ScreenUpdating = True
End Sub