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: 7
Default Form does not disappear

Project has two forms: formMain and formHelp.

formMain has two buttons:
"Help" button with code formHelp.Show
"Hide" button with code Me.Hide

formHelp has a "Close" button with code Unload Me

When formMain first shows I can move it around with no trail in the
background.

Two problems occur when formHelp shows:
When I move it around, it leaves a trail.

When I press formHelp's Close button, formMain appears but formHelp
(larger than formMain) still shows in the background. When I now move
formMain around, it also leaves a trail.

The same problems occur if I close formHelp with the red X close.
I get the impression something is wrong with formHelp.

If I click formMain's Hide button, both forms and their trails
disappear.

An earlier version does not have this problem; I don't know what caused
the change.

I've tried these ideas from another post:
(1) move code from form module to code module.
(2) insert Application.ScreenUpdating toggle.

Sub HelpShow()
formHelp.Show
Application.ScreenUpdating = False
Application.ScreenUpdating = True
End Sub

Sub HelpClose()
Unload formHelp
Application.ScreenUpdating = False
Application.ScreenUpdating = True
End Sub

These did not resolve the problem.

I have XP and Excel 2000.

Thanks,
George

 
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
Menu Bar disappear Lucy Excel Discussion (Misc queries) 1 September 19th 08 07:52 PM
why workbook disappear ? fathy Excel Worksheet Functions 1 March 21st 07 05:52 PM
Tabstrip tabs entered programmatically disappear after form unload cumchee Excel Programming 1 January 21st 05 08:04 PM
Add-Ins disappear Gates72 Setting up and Configuration of Excel 0 December 2nd 04 04:06 PM
Form Doesn't Disappear Stratuser Excel Programming 2 October 13th 04 10:39 PM


All times are GMT +1. The time now is 10:26 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"