Thread: Forms.Close
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Robin is offline
external usenet poster
 
Posts: 1
Default 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?