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

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

Worksheet appears briefly before UserForm opens
 

on 6/29/2011, Rob Flott supposed :
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

I tried this using Workbook_Open event and the worksheet fully displays
as usual, and the userform displays as expected. Not sure why you only
get partial worksheet. (The userform is blank, FYI)

--
Garry

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