arsenal_fan 0 Newbie Poster

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.