+ Reply to Thread
Results 1 to 3 of 3

How do I close a workbook without prompting to save file?

  1. #1
    Forum Contributor rkjudy's Avatar
    Join Date
    03-31-2009
    Location
    Longview, TX
    MS-Off Ver
    MS Office 2010
    Posts
    239

    How do I close a workbook without prompting to save file?

    I just want the workbook to close, with asking if I want to save file, when I click the close (X) button.

    I had it working previously. It seems this quit working after I recently added some code to create a PDF of a sheet and then email it.

    Here's the code I was using that worked for a long time.

    Please Login or Register  to view this content.
    This code is in the ThisWorkbook module.
    Last edited by rkjudy; 05-05-2014 at 06:30 PM.

  2. #2
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: How do I close a workbook without prompting to save file?

    this statement disables all pop up messages in that excel session its run

    Please Login or Register  to view this content.
    so make it

    Please Login or Register  to view this content.
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

  3. #3
    Forum Contributor rkjudy's Avatar
    Join Date
    03-31-2009
    Location
    Longview, TX
    MS-Off Ver
    MS Office 2010
    Posts
    239

    Re: How do I close a workbook without prompting to save file?

    Works perfect. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-25-2013, 06:10 PM
  2. Replies: 0
    Last Post: 08-21-2013, 12:09 PM
  3. [SOLVED] File closes without prompting to save
    By freyabeads in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 09:10 AM
  4. [SOLVED] calculation - prompting to save when file closes
    By lpj in forum Excel General
    Replies: 0
    Last Post: 02-14-2006, 04:30 PM
  5. [SOLVED] [SOLVED] Close Excel file without prompting user to save
    By JDay01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-10-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1