Jollynicechap,

You could try this, but be careful with it as an error in the wrong
place might cause havoc.

Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub

You'll need to include an
Application.Visible = True
somewhere to get Excel back into view.

John

Jollynicechap wrote:

Thanks Dan

Changing this gives me RTE 9 "Sub-script out or range". Thinking about it, I
really need to hide Excel & only disply the form. What is the easiest way of
doing this?

Paul