#1   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 with two windows in Windows 7 Bob Excel Discussion (Misc queries) 0 January 15th 10 02:20 PM
i want all windows in one excel frame (windows in taskbar) Subramanya Excel Discussion (Misc queries) 1 December 18th 09 03:14 PM
cannot open exel from windows xp in windows vista and visa versa lildiana New Users to Excel 4 February 25th 09 07:26 PM
can windows vista edit shared document from windows xp sasa Excel Worksheet Functions 1 January 9th 08 06:44 PM
Page breaks are different in Windows 2000 and Windows XP Bill Allen Excel Discussion (Misc queries) 1 November 23rd 05 04:42 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"