+ Reply to Thread
Results 1 to 2 of 2

Disable Save Workbook popup

  1. #1
    Scott buckwalter
    Guest

    Disable Save Workbook popup

    I have a workbook that I do not want the user prompted to save whenever they
    close it. Is there a way I can disable that popup? Maybe override the
    Workbook_OnClose event?

  2. #2
    Scott buckwalter
    Guest

    RE: Disable Save Workbook popup

    Found it.

    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Me.Saved = True
    End Sub

    Works.

    "Scott buckwalter" wrote:

    > I have a workbook that I do not want the user prompted to save whenever they
    > close it. Is there a way I can disable that popup? Maybe override the
    > Workbook_OnClose event?


+ 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