View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Henry[_5_] Henry[_5_] is offline
external usenet poster
 
Posts: 104
Default Window's System Menu, can't remove menu

Yuri,

If you make your userform full screen, *none* of the toolbars are
accessible.
Disable the "X" on your form and the only way a user can get out of the form
is to click your Exit button on the form.

Private Sub UserForm_Initialize()
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With
End Sub

HTH
Henry


"Yury Lobanov" wrote in message
...
Not to find how to trap window closing i'm trying to disable "X"-button,
and System menu. With API.

API's "RemoveMenu" works with Forms but not with Worksheet Windows!!!
"X"-button can be disabled, but System Menu - can't!!

is it impossible to remove items of System Menu of a Worksheet Window????

Yury