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: 10
Default Worksheet appears briefly before UserForm opens

I am in Excel 2007 and have a workbook with a UserForm and several
worksheets. I set it so when the workbook is opened it will open the
UserForm. Furthermore when the UserForm is activated it launches a
macro that loads a list of names into the first ListBox in the
UserForm.

Anyway, the problem I have is when I open the workbook a portion of
one worksheet appears for a few seconds and then the UserForm opens
and everything is fine from there on. I've looked all over and cannot
figure why this one worksheet always appears first before the UserForm
opens.

Does anyone have any ideas?

TIA,

Rob
 
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
Floating userform appears on task bar??? Robert Crandal Excel Programming 7 December 7th 09 11:14 AM
Show Userform when Application Opens ironhydroxide Excel Programming 2 August 18th 09 11:19 PM
Linked PDF files open briefly and then close Stella Rivera Excel Discussion (Misc queries) 2 January 27th 09 04:02 PM
Userform appears behind other application simonc Excel Programming 4 September 10th 08 05:03 PM
Code Locks Up Worksheet Briefly Arnold[_3_] Excel Programming 0 January 5th 07 04:28 AM


All times are GMT +1. The time now is 10:30 AM.

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"