Results 1 to 11 of 11

How to avoid Excel save pop-up

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    12

    Question How to avoid Excel save pop-up

    During workbook close, how to avoid excel save, don't save pop-up.
    We already fool the excel by telling it, we saved.. But still the pop-up is throwing.
    It is not coming for all excels we have. I have a .xlsm file, only for which it is coming. Sorry that I can't able to share my program.
    Following is my workbook close event in vba.

    Private Sub App_WorkbookBeforeClose(ByVal wb As Excel.Workbook, Cancel As Boolean)
    My code
    wb.saved = True
    End Sub

    I also tried Activeworkbook.Saved = True, Thisworkbook.Saved = True, nothing is working fine..
    Please leave your inputs to solve this.
    Attached Files Attached Files
    Last edited by Rayner; 10-25-2013 at 03:05 AM. Reason: Attached File

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] assign code to avoid the pop up comp-ability check mode save option
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:27 AM
  2. How to disable the save dialog box and avoid workbook to close
    By gozeimas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2013, 07:26 AM
  3. How to avoid an error, if you press cancel on a SAVE FILE-Macro
    By Silas313 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2010, 04:56 AM
  4. avoid save file
    By eugz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2009, 12:20 PM
  5. [SOLVED] Excel - highlight new data (by date ?) and avoid 'Save As'
    By Tom in forum Excel General
    Replies: 0
    Last Post: 10-17-2005, 04:05 PM

Tags for this Thread

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