MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Closing worksheets without saving them

  Asked By: Adelina    Date: Nov 15    Category: MS Office    Views: 1893

Just wondering how can I close a worksheet without saving it in Excel
Macro? Also, how can I name a newly opened Excel work book using Excel



2 Answers Found

Answer #1    Answered By: Gregg Bennett     Answered On: Nov 15

Call ActiveWorkbook.Close(SaveChanges:=False)

You don't name an Excel workbook. You name the file you save it to.

Answer #2    Answered By: Madiha Malik     Answered On: Nov 15

Here is the code to close  without saving
ActiveWorkbook.Close False
To save newly open excel  sheet with name
ActiveWorkbook.SaveAs Filename:="Your Desired Name"

Didn't find what you were looking for? Find more on Closing worksheets without saving them Or get search suggestion and latest updates.