Writing a macro that will exit a spreadsheet

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

Guest

Hi there.

I am designing a spreadsheet and have various macros running, print, save
etc, allocated to buttons on the sheet. However I would like to have a macro
that also exits the spreadsheet when I run it, unfortunately when I try and
record the macro I exit ok but the macro doesn't record. Any tips please?
 
I'm no expert, still learning the macro stuff myself,.
This has worked for me though... also upon a button_click Command.
this one saves first, then exits.

Sub SaveClose()
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
 
Back
Top