Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms.Close
I have a macro with a number of userforms, I want to be
able to close them all at once as sometimes multiple copies of the same form lie under the topmost one. VBE help says I can use Sub CloseForm() Forms("MyForm.frm").Close End Sub or Sub CloseAll() Forms.Close End Sub I tried using these in a Public Sub placed in a module and called from a command button on each form. However, I get this error message. Sub, Function, or Property not defined (Error 35) Any ideas why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
close button does not close | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |