HI TEAM..
I HAVE THE FOLLOWING CODE WHICH CLOSES ALL MY ACTIVE WORKSHEETS AND ENDS EXCEL APPLICATION
Sub Save_Exit()
Application.Quit
ActiveWorkbook.Saved = True
End Sub
BUT WHAT I WANT BE ABLE TO DO IS WHEN A RUN THE MACRO IT SHOULD CLOSE ALL OPEN WORKBOOK WITHOUT SAVING ANY CHANGES MADE AND LEAVING ONE EXCEL WORKBOOK (ie.OTC.XLSX) REMAIN OPEN
FOR EXAMPLE:
I HAVE OPENED BOOK1 ,BOOK2 , AND OTC.XLSX WORKBOOK WHEN I RUN THE MACRO IT SHOULD CLOSE BOOK 1 AND BOOK 2 LEAVING OTC.XLSX OPEN
NOTE: BOOK 1 AND BOOK 2 MAY CHANGE BUT THEY WILL BE EXCEL FILES ONLY
THANKS IN ADVANCE
Bookmarks