| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Floating userform appears on task bar??? | Excel Programming | |||
| Show Userform when Application Opens | Excel Programming | |||
| Linked PDF files open briefly and then close | Excel Discussion (Misc queries) | |||
| Userform appears behind other application | Excel Programming | |||
| Code Locks Up Worksheet Briefly | Excel Programming | |||
Hybrid Mode
