I have a list box on a splash screen excel sheet.

I have put the fullscreen menu choice on the main menu for ease of access by
users of my workbook.

When the sheet is activated, the list box is loaded with all worksheets
meeting my criteria (in this case, if the worksheet name contains the text
"DSH"). Instructions on the page tell the user to choose a worksheet from the
list.

This all works exactly as needed.

The problem is that when fullscreen mode is entered or exited when this page
is displayed, the display of the listbox is corrupted. The top of the listbox
is overwritten by what was previously displayed at that point on the screen.

I have bitmaps showing this, but I can't attach them to this posting, to
anyone interested, let me know and I'll send them to you.

I would like to know if there is a "refresh" or trick I can use to update
the window or control programmatically to reset it's true image. (I can put
that code into the routine which executes fullscreen.)

I am running excel version 2000, 9.0.8961 SP-3 on a windows 2000 machine.

BUMP
<please

"Steve the large" wrote:

I have a list box on a splash screen excel sheet.

I have put the fullscreen menu choice on the main menu for ease of access by
users of my workbook.

When the sheet is activated, the list box is loaded with all worksheets
meeting my criteria (in this case, if the worksheet name contains the text
"DSH"). Instructions on the page tell the user to choose a worksheet from the
list.

This all works exactly as needed.

The problem is that when fullscreen mode is entered or exited when this page
is displayed, the display of the listbox is corrupted. The top of the listbox
is overwritten by what was previously displayed at that point on the screen.

I have bitmaps showing this, but I can't attach them to this posting, to
anyone interested, let me know and I'll send them to you.

I would like to know if there is a "refresh" or trick I can use to update
the window or control programmatically to reset it's true image. (I can put
that code into the routine which executes fullscreen.)

I am running excel version 2000, 9.0.8961 SP-3 on a windows 2000 machine.

Fixed it myself. Figured out a work-around. Thanks anyway.

"Steve the large" wrote:

BUMP
<please

"Steve the large" wrote:

I have a list box on a splash screen excel sheet.

I have put the fullscreen menu choice on the main menu for ease of access by
users of my workbook.

When the sheet is activated, the list box is loaded with all worksheets
meeting my criteria (in this case, if the worksheet name contains the text
"DSH"). Instructions on the page tell the user to choose a worksheet from the
list.

This all works exactly as needed.

The problem is that when fullscreen mode is entered or exited when this page
is displayed, the display of the listbox is corrupted. The top of the listbox
is overwritten by what was previously displayed at that point on the screen.

I have bitmaps showing this, but I can't attach them to this posting, to
anyone interested, let me know and I'll send them to you.

I would like to know if there is a "refresh" or trick I can use to update
the window or control programmatically to reset it's true image. (I can put
that code into the routine which executes fullscreen.)

I am running excel version 2000, 9.0.8961 SP-3 on a windows 2000 machine.