Hi,
I am using excel to load a userform that will run a macro to perform processing on excel sheets. I have set the userform to load when you double click the macro-enabled excel sheet. Everything works fine except I can briefly see worksheets before the userform appears. How do I ensure that worksheets arent visible even briefly when I double click
the macro-enabled excel sheet. I'd like the userform to load right away.
My ThisWorkbook code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
userform.Show
Application.Visible = False
End Sub