LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default UserForm image stays when form is dragged to another area

I have a spreadsheet with about 8 worksheets. I display only one at a time,
the sheet displayed is based on procedures invoked on the spreadsheet and
forms. When I load a form, I set Application.ScreenUpdating to false so the
worksheets in the background can be unhid and unprotected to perform the
procedure. When the form is closed all of the worksheets except one is
re-hidden and all are reprotected.

I noticed when I use Office 2003 an image of the form remains if the user
drags the form to another location on the screen. It doesn't disapear until
the form is closed or the user performs a click commandbutton. I know the
problem has to do with screen updating being disabled but I can't figure out
how to "refresh" the screen when the user finishes dragging the form. I
tried "mouseup" thinking when the user releases the form it would invoke an
event to turn screen updating on and then turning it back off, but that
didn't seem to work. Any ideas?

Thanks

Brad Smith
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing spreadsheet print area to 1 page fails to shrink image en zipidy Excel Worksheet Functions 0 June 25th 09 02:46 AM
VBA to display image on a form - image is defined in Range Name Tan Excel Programming 4 May 17th 06 03:37 PM
Prevent UserForm on top of a worksheet from being dragged around screen L Mehl Excel Programming 8 October 25th 04 07:39 PM
Help! Animated gif-image in form does not show animation when form loaded JoCa Excel Programming 4 September 23rd 04 07:43 PM
Set Print Area = Image?? dave_d Excel Programming 2 August 26th 03 04:44 AM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"