.Visible Property
 

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

.Visible Property
 

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