Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel screen repaint problem

Status
Not open for further replies.

KeyserSoze

Programmer
May 18, 2000
79
US
I have a form in Excel 2002 VBA that opens another form. The second form does manipulations on a worksheet. When the second form is closed via an "Unload Me" command, it seems to remain painted on the screen behind the calling form. Also, when you grab the original form, it creates after-images of itself, kind of like how Bruce Lee's hands moved in the movie "The Chinese Connection" or if you are on a acid trip.

One thing of note: if the sheet that I am doing manipulations on is a hidden sheet, the above scenario occurs. However, if I unhide the sheet, the screen is repainted correctly.

I can change my code to temporarily unhide the sheets but if there is a simple workaround I'm all for that.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top