LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 160
Default Auto-Open procedure

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bypass Auto-Open Procedure QB Excel Discussion (Misc queries) 1 October 6th 09 04:29 PM
Why is my Workbook Open procedure not working Ron McCormick[_6_] Excel Programming 1 July 15th 04 12:13 PM
programmatically open VBE and go to a specified procedure in target module? DataFreakFromUtah Excel Programming 4 July 12th 04 05:37 PM
My syntax not working with Auto Open procedure Graham[_5_] Excel Programming 2 April 1st 04 05:08 PM
Workbook.Open Event Procedure not firing Gordon Rodman Excel Programming 1 October 17th 03 05:03 PM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"