Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shadows with forms
Hi,
I was wondering why sometimes, when I have a userform on top of a sheet, if you move it by dragging the titlebar, it let's shadows behind it, so you can't see what's on the sheet, and sometimes, it doesn't. I have a userform, if just loaded, it doesn't let see what is behind it when you move it, but if you choose an item from a list on that form, suddenly, you can move the form and see behind. Is it a property or something like that? I would like to avoid the shadow! Thanks for your reply Jos Vens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shadows with forms
If ScreenUpdating is set to False it will do this.
-- Regards, Tom Ogilvy "Jos Vens" wrote in message ... Hi, I was wondering why sometimes, when I have a userform on top of a sheet, if you move it by dragging the titlebar, it let's shadows behind it, so you can't see what's on the sheet, and sometimes, it doesn't. I have a userform, if just loaded, it doesn't let see what is behind it when you move it, but if you choose an item from a list on that form, suddenly, you can move the form and see behind. Is it a property or something like that? I would like to avoid the shadow! Thanks for your reply Jos Vens |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shadows with forms
Thanks Tom,
sometimes, solutions are so simple!!! Jos "Tom Ogilvy" schreef in bericht ... If ScreenUpdating is set to False it will do this. -- Regards, Tom Ogilvy "Jos Vens" wrote in message ... Hi, I was wondering why sometimes, when I have a userform on top of a sheet, if you move it by dragging the titlebar, it let's shadows behind it, so you can't see what's on the sheet, and sometimes, it doesn't. I have a userform, if just loaded, it doesn't let see what is behind it when you move it, but if you choose an item from a list on that form, suddenly, you can move the form and see behind. Is it a property or something like that? I would like to avoid the shadow! Thanks for your reply Jos Vens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shadows and printing | Excel Discussion (Misc queries) | |||
Shadows don't work right in Office 2007? | Excel Discussion (Misc queries) | |||
Shadows of the Pivottable Field List while macro is running | Excel Worksheet Functions | |||
Calling Forms from Forms - Exit problems | Excel Programming | |||
Userform shadows | Excel Programming |