[notquiteanexpert]

Hi Guys,

I am writing some software that uses Excel sheets purely to store data and all controls/inputs to be run from a form. I am having problems minimising the Excel window and opening the form when the workbook opens. I have tried the following:

Sub Workbook_Open()
Application.WindowState = xlMinimized
frm_Main.Show
End Sub

I have also tried various combinations like:

Sub Workbook_Open()
Application.WindowState = xlMinimized
frm_Main.Show
Application.WindowState = xlMaximized
End Sub

and

Sub Workbook_Open()
frm_Main.Show
Application.WindowState = xlMinimized
End Sub

None of these seem to work as required......they either minimise both the form and window, or neither.

Any help would be extremely appreciated!!

Thanks!