exit excel

[kalpeshpatel]

how to exit excel when i click a button the excel was close

any macro

 

[SirJB7]

Hi, kalpeshpatel!


Do you mean something like?

Application.Quit


Otherwise please elaborate it a bit more. Thank you.


Regards!

 

[nazmul_muneer]

ActiveWorkbook.Close savechanges = True ' Close without Saving

ActiveWorkbook.Close savechanges = False ' Close with Saving

 

[Girish7919]

Can you us in details, exit the macros when they are running when you click close button in excel?

 

[SirJB7]

@Girish7919

Hi!

Sorry but I don't understand your question. If it's related to the same issue that started this topic, please elaborate a bit more. If it's not related, I'd suggest you to do the same but starting a new topic.

Regards!

 

[sgmpatnaik]

Hello Sir, SirJB7


Good Evening Sir, I Hope your angry is calm down on me


Sir here is a code for Command Button but it needs to save the work Book in macro Enable format type


the command is


Private Sub CommandButton1_Click()

If MsgBox("Do you want to quit Excel", vbYesNo) = vbYes Then


Application.Quit

Else


Sheets("Sheet1").Activate

End If

End Sub


I hope this command is help full to Mr. kalpesh Patel


With Regards


patnaik