Trying to hide Minimize and Restore Down

I searched online line for help but can't find any. I am looking for code to make macro to hide the Minimize & Restore Down buttons upon opening the file and unhiding them when closing file. Any help is appreciated.

Unfortunately this is not possible as those features are part of Windows and not related to Office/Excel etc.

You do have some options. This suggestion from Nimrod may be of use for you;

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 .

Thank you. I will run it and see how it works.