MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hide Minimize/Maximize/Close buttons

Posted by Matthias Preuter on April 03, 2001 12:17 AM

I have to change a program, that is totaly MenuBar driven, that crashes when a workbook is closed or minimized thru this buttons.

Is there a way to hide the Minimize/Maximize and Close Buttons from a worksheet? I did found somthing like it for a Form, but not for workbooks.


Matthias Preuter
Extreme Team / NUON EnergyTrade&Wholesale
The Netherlands

Posted by Dave Hawley on April 03, 2001 12:47 AM

Hi Matthias

I assume you are talking about the X in the top right of the screen for the active Workbook. If so, go to Tools>Protection>Protect Workbook and check the "Windows" check box.

DaveOzGrid Business Applications