Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form wont hide
It looks like you are not ever allowing your events to terminate - probably
why you are having memory problems as well. -- Regards, Tom Ogilvy "Chad" wrote in message ... I'm having trouble with my form not hiding. I think it has something to do with screenupdating turned off, but that command comes after the hide command. Here's my code: I run this macro which calls up the form: Sub Face_Sheet() UserForm2.Show End Sub The form has a button which runs the report and this is the macro: Sub main(printall As Variant, officeloc As Variant) Dim Rng1, Rng2, col, i As Integer Dim LRow, RowSkills, RowAvail As Integer UserForm2.Hide Unload UserForm2 If printall = 1 Then Sheets(officeloc).Select: Columns("a:ee").Delete Application.ScreenUpdating = False ...code continues The problem is that the form remains on the screen and doesn't disapear. How can I make it go away? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form wont hide
Okay, how do I terminate my subs?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide or display worksheets based on form | Excel Discussion (Misc queries) | |||
how to hide a form button in a worksheet | Excel Discussion (Misc queries) | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
How do I hide zero values but keep currency format in P.O. form? | New Users to Excel | |||
Hide minimise, maximise, and close buttons on form | Excel Programming |