Disabling the close box in Excel 1

[VBRookie]

Hi,

Does anyone know how to disable or remove the close box using VBA? I'm opening up excel in my VB app and I don't want the user to close the spreadsheet by clicking on the close box. I only want them to be able to do it through the VB app.

Any help you can offer would be greatly appreciated.

Thanks,
- VB Rookie

 

[Store300]

If you want them to close it through VBA so that certain routines can be run it may be worth using the workbookbeforeclose event which will run if the user clicks the close button.