![]() |
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. |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com