View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default USERFORM DISAPPEARS ON EXCEL MINIMIZE

I haven't observed this behavior.

as an example, putting this in the userform module:

Private Sub UserForm_Initialize()
Application.Visible = False
End Sub

Private Sub UserForm_Terminate()
Application.Visible = True
End Sub


worked fine, showing the useform as modal or modeless

--
Regards,
Tom Ogilvy


"Ian Digby" wrote in message
...
When I minimize Excel, my VBA Userforms disappear. I thought the Userform
ThunderdFrame class window was not a child of Excel, so why does it
disappear?

Any help would be much appreciated.
--
Work performed in the spirit of service is worship...Baha'i Writings