Disable Worksheet buttons

[SK Manocha]

I need to disable the three buttons to minimise, restore and close buttons of the Worksheets for the application I am working on in Excel 07.
Is there any direct method ( as available for userform) and indirect way to do this? A way to keep the window always maximised would do the trick.
Thanks
SKM

 

[crimson_b1ade]

Paste the below into ThisWorkbook module:

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

 

[SK Manocha]

Thanks.
The action suggested takes care of half of the problem. Main Title bar XL logo and Minimise, Restore Down/Maximise and Close buttons are not yet disabled for their action. Possibly the shortcut menu disabling may help.

SKM

 

[crimson_b1ade]

If there's a way to do that then I certainly don't know it. Sorry!

 

[Jaafar Tribak]

Is there any direct method ( as available for userform) and indirect way to do this?

Do a search for how to disable the caption buttons of a userform and follow the same technique only in this case it will work on the Application.Hwnd Property. It's the same principle ie : use the SetWindowLong with the GWL_STYLE flag to change the main window styles.

Regards.