View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
151 151 is offline
external usenet poster
 
Posts: 2
Default removing maximize control from excel application (not justworksheet)?

hi all,

I am trying to remove the maximize control (the small square control
common to most windows) from the top right of Excel (the application,
not just the worksheet) and I can remove everything BUT the maximize
and minimize controls with code similar to:

lHandle = FindWindowA(vbNullString, Application.Caption)
If lHandle < 0 Then
DeleteMenu GetSystemMenu(lHandle, False), 0, MF_BYPOSITION
DeleteMenu GetSystemMenu(lHandle, False), 1, MF_BYPOSITION
.....etc

A variation of the code above removes the maximize option from the
system menu but does NOT remove the maximize icon (the small square)
too. Strangely I can disable the "X" that closes the application
without any problems....

Is it possible to do it? I want to stop the user maximizing Excel as
I am trying to make the worksheet look like more of a standalone
application. Its working pretty well apart from this issue!

thanks guys!

Gav