Closing file and excel

[Jean-Paul De Winter]

Hi,
I created a pushbutton with following code:

Private Sub CommandButton4_Click()
ActiveWorkbook.Close
End Sub

When I click I am asked if I want to save the workbook....
Tha idea is, when clicking the button, ALWAYS save the wrokbook and close
excel.

What code should I add?

Thanks

 

[Frank Kabel]

Hi
try
Private Sub CommandButton4_Click()
activeworkbook.save
application.quit
end sub

 

[Jean-Paul De WInter]

great... just what I wanted
Thanks
JP

Hi
try
Private Sub CommandButton4_Click()
activeworkbook.save
application.quit
end sub