Thread: Save/exit macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andrewbt andrewbt is offline
external usenet poster
 
Posts: 14
Default Save/exit macro

hello all (again).
Im currently using this code below for exiting my system

Sub Save_Exit()
Application.Quit
ThisWorkbook.Close SaveChanges:=True
End Sub

Pretty simple i know, but what i really really need is some way of saving
the workbook but deleting all of the worksheets apart from "Worksheet 1". If
anyone can help me i will be very grateful. Thanks a bunch.
Andrew