Worksheet appears briefly when workbook hidden

[Bushopper]

Hi!

My program opens with a userform for input and I have set the workbook visible equal to false. It works but on opening the worksheet briefly appears. Looks amateurish. Could someone please check my code and advise? I have tried putting 'Application.Visible = False' and 'FrmCompData.Show' first but without success.

Thanks in anticipation.

Bushopper

My code is:

Private Sub Workbook_Open()

Application.ScreenUpdating = False
Application.Visible = False
frmCompData.Show

End Sub

[JasperD]

It will never be entirely hidden - if the user doesn't automatically allow macros, it will stay visible until (s)he clicks "enable macros".
It's best to open the workbook with just a 'splash screen' visible until the user allows macros.