Hide Close Button

[baggers719]

Hi,

I am using Excel 2007 and would like to hide the close button on the worksheet when it opens. I tried searching for it but been a little unsuccessful for what I want.

Appreciate your help as always!

Sean.

 

[nuked]

This is not easy and would require an API or two.

You could disable it quite easily:

Alt+F11
Double Click 'ThisWorkbook' on left-hand side
Paste this on the right-hand side

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