Can the X to Close button on a workbook be disabled?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to use vba code to disable the X to close button on an open workbook. I have placed a command button on a worksheet and do not want the user to be able to close the workbook without clicking the command button.
 
Hi

Place in the ThisWorkbook module:

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

Now the workbook can't close at all. You take it from there.

HTH. Best wishes Harald

Eric said:
Does anyone know how to use vba code to disable the X to close button on
Click to expand...
an open workbook. I have placed a command button on a worksheet and do not
want the user to be able to close the workbook without clicking the command
button.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing another file by code causes failure to run workbook activate event 2
STOP close button on another workbook 6
Excel Providing user message when RED X clicked & properly closing application. 2
Command button naming issue 1
Closing a workbook 5
command button help 3
Close WorkBook 5
Problem with ActiveWorkbook.Close command 3

Back
Top