View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Worksheet appears briefly before UserForm opens

Rob Flott formulated on Wednesday :
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


Can you post the code?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc