Thanks

2 possible options - great

"Dave Peterson" wrote:

How about hiding the application?

application.visible = false
'show your form, do your stuff

'But remember to turn it back on (sometime)
application.visible = true



patrick wrote:

I am attempting to write an auto open procedure that minimizes the Excel
application and then displays the first menu form. The code I have used is:

Sub Auto_Open()

Application.WindowState = xlMinimized
fmMenuMain.Show

End Sub

This minimizes Excel but does not correctly display the form - the tab on
the taskbar flashes & has to be 'clicked' to display the form. Can anyone
help with curing this - to allow the workbook to be minimized and to display
the form correctly?

Thanks in anticipation

Patrick

--

Dave Peterson