Thread: Windows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Windows

If you protect the workbook (not the worksheet), then the minimize and
maximize icons are removed from the workbook menu. This still allows the
application to be minimized (I am not sure which action causes the menu to
be reset).

If you need to do this to the Application window (Excel), you have to use
the windows API:

http://support.microsoft.com/?id=107689
XL: Disabling Microsoft Excel Control Menu Commands

http://support.microsoft.com/?id=117855
XL: Removing the Control Menu and Application Window Controls


http://support.microsoft.com/?id=147659
HOWTO: Get a Window Handle Without Specifying an Exact Title

http://support.microsoft.com/?id=112649
HOWTO: Get a Window's Class Name and Other Window Attributes


the first two show you how. The second two just provide some useful
information about working with windows and using the API.

Regards,
Tom Ogilvy

"Phil Perry" wrote in message
...
Is there a code to prevent users from minimising windows
on an excel spreadsheet by clicking on the taskbar- the
problem is that it opens again with a different set of
toolbars. Thanks.