Disable minimize maximize buttons

Maybe you could keep things simple by setting your desired screen size and then protecting the workbook with True for the Windows argument. The Structure argument is bypassed on purpose for brevity, which you could insert if you don't want the sheets rearranged. Example:

ActiveWindow.WindowState = xlNormal
ActiveWorkbook.Protect Password:="YourPassword", Windows:=True

This will take those min, max, restore, and close buttons off the active workbook window's title bar (not the Excel application title bar).

'To unprotect the workbook:
ActiveWorkbook.Unprotect Password:="YourPassword"

Thanks for your reply Tom,

I was hoping to be able to disable the application min/max/close buttons, is this possible?

Thanks
kd

OPTION 1
The following statement will prevent windows from being minimized:

ActiveWindow.EnableResize = False


OPTION 2
You can do this with the Workbook_WindowResize event procedure. Put the following code in the workbook code module.

Private Sub Workbook_WindowResize(ByVal Wn As Window)
Wn.WindowState = xlMaximized
End Sub


TO PREVENT APP AND WorkBook Closure:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub

SHEET IN FULL SCREEN VIEW :
Public Sub FullScreenView()
Application.DisplayFullScreen = True
End Sub



NOTE: This code needs to be inserted in the "ThisWorkBook" Code Window .