+ Reply to Thread
Results 1 to 7 of 7

Force save on exit

  1. #1
    Registered User
    Join Date
    05-11-2010
    Location
    A far away land
    MS-Off Ver
    Excel 2003
    Posts
    38

    Question Force save on exit

    Is it possible to force a user to save on exit. I added a button to run save and exit but they are still closing with the x.
    Last edited by Rodeoclown; 05-20-2010 at 07:44 AM.

  2. #2
    Registered User
    Join Date
    05-11-2010
    Location
    A far away land
    MS-Off Ver
    Excel 2003
    Posts
    38

    Search a sheet in different workbook

    Posted in wrong thread
    Last edited by Rodeoclown; 05-20-2010 at 07:32 AM. Reason: Posted in wrong thread

  3. #3
    Forum Contributor wamp's Avatar
    Join Date
    11-10-2008
    Location
    Norway
    MS-Off Ver
    97, 2000 & 2003 (diff. workstations)
    Posts
    184

    Re: Force save on exit

    Why not just make the sheet save itself if/when the user hit's the "X"?

    Place the following code in "ThisWorkbook" (right-click on any sheet, select "view code", click on 'ThisWorkbook'
    Please Login or Register  to view this content.
    _______________________________________________
    Remember:

    Read the rules!

    Use code tags! Place [CODE] before the first line of code and [/CODE] after the last line of code.

    Mark your post [SOLVED] if it has been answered satisfactorily.
    To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!

    If you are approve (or disapprove) of any members response to your problem, please click the star icon underneath their post and comment. It matters.

  4. #4
    Registered User
    Join Date
    05-11-2010
    Location
    A far away land
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: Force save on exit

    That will work. Thanks

  5. #5
    Registered User
    Join Date
    05-11-2010
    Location
    A far away land
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: Force save on exit

    That will work. Thanks

  6. #6
    Registered User
    Join Date
    06-06-2013
    Location
    Crazytown
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Force save on exit

    What does "Application.EnableEvents = True/false" in this accomplish?

  7. #7
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Force save on exit

    gsweeney5150,
    Please do not resurrect old threads. Further, do not post your question in the thread someone else has started - this is known as thread hijacking and is against the Forum Rules.
    Always start your own thread and, if it helps to clarify your needs, provide a link back to other threads.

    I suggest you take the time to read the Forum Rules so that you can avoid infractions that will impact your posting privileges.
    Ben Van Johnson

+ 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