+ Reply to Thread
Results 1 to 3 of 3

disabling Excel pop-up dialog boxes

  1. #1
    John
    Guest

    disabling Excel pop-up dialog boxes

    I'd like to know how to close a spreadsheet unconditionally without incurring
    a saving dialog popup box (that requires operator input). I believe it can
    be done using VB, and I'd like to know how to do this; if there is a way to
    manually configure Excel when I first open Excel (2003), this may also work.
    Thanks.

  2. #2
    Jim Rech
    Guest

    Re: disabling Excel pop-up dialog boxes

    There is no setting in Excel for this. The only approach I can think of is
    to set an application level event handler (in an add-in I think) that
    intercepts the Before_Close event of all workbooks and sets their Saved
    property to True. Chip Pearson has a page describing application event
    handlers:

    http://www.cpearson.com/excel/AppEvent.htm

    --
    Jim Rech
    Excel MVP
    "John" <John@discussions.microsoft.com> wrote in message
    news:8294485E-3E61-4B69-B5CF-B6ABF61B51CF@microsoft.com...
    | I'd like to know how to close a spreadsheet unconditionally without
    incurring
    | a saving dialog popup box (that requires operator input). I believe it
    can
    | be done using VB, and I'd like to know how to do this; if there is a way
    to
    | manually configure Excel when I first open Excel (2003), this may also
    work.
    | Thanks.



  3. #3
    Gary Brown
    Guest

    RE: disabling Excel pop-up dialog boxes

    Try:

    Application.Quit
    Application.ActiveWorkbook.Close savechanges:=False

    HTH,
    Gary Brown

    "John" wrote:

    > I'd like to know how to close a spreadsheet unconditionally without incurring
    > a saving dialog popup box (that requires operator input). I believe it can
    > be done using VB, and I'd like to know how to do this; if there is a way to
    > manually configure Excel when I first open Excel (2003), this may also work.
    > Thanks.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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