View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How to stop Stephen Bullen's CFormChanger from minimizing as an MDI title bar?

If I execute the SW_MINIMIZE too, it un-hides again.)

It shouldn't unhide it, merely minimize it to the taskbar. Are you using the
example exactly as I posted it?

If you only do SW_HIDE you won't be able to manually restore it, only way
would be to have stored the form's window handle in a way that be retrieved
in a normal module and do:
ShowWindow hwnd, SW_NORMAL ' 1

Regards,
Peter T

"Jim Luedke" wrote in message
...
Peter:

Works like a charm.

(Except, it's:

Private Sub UserForm_Resize()
If IsIconic(hWnd) Then
Call ShowWindow(hWnd, SW_HIDE)
' Call ShowWindow(hWnd, SW_MINIMIZE)
End If
End Sub

If I execute the SW_MINIMIZE too, it un-hides again.)

Thanks a-much.

***