Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I drag a form over my screen it remains visible at the place wher it
left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I avoid that? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Henk" wrote: When I drag a form over my screen it remains visible at the place wher it left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I avoid that? Try shut down your system and restart- first solution |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sinecodap,
tHenks for your suggestion, but it is happening for several weeks already and as far as I can remember, I did shut down and restarted my system many times. Did not help. "sinecodap" wrote: "Henk" wrote: When I drag a form over my screen it remains visible at the place wher it left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I avoid that? Try shut down your system and restart- first solution |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Henk" wrote in message
... When I drag a form over my screen it remains visible at the place wher it left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I avoid that? Hi Henk, This is usually the result of having set Application.ScreenUpdating = False at some point before showing your form. Make sure to set Application.ScreenUpdating = True just before you show your form and the problem should go away. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Great! That's it!
tHenks. "Rob Bovey" wrote: "Henk" wrote in message ... When I drag a form over my screen it remains visible at the place wher it left. So, if I drag the form 5 times, I see 5 forms on my screen. How can I avoid that? Hi Henk, This is usually the result of having set Application.ScreenUpdating = False at some point before showing your form. Make sure to set Application.ScreenUpdating = True just before you show your form and the problem should go away. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dragging | Excel Worksheet Functions | |||
Dragging VLOOKUP | Excel Discussion (Misc queries) | |||
About this dragging... | Excel Discussion (Misc queries) | |||
dragging | Excel Discussion (Misc queries) | |||
Dragging Across | Excel Discussion (Misc queries) |