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!