+ Reply to Thread
Results 1 to 3 of 3

Auto Save (in background/with no prompt) upon leaving cell... how?

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Earth
    MS-Off Ver
    2007
    Posts
    43

    Auto Save (in background/with no prompt) upon leaving cell... how?

    I am still getting the hang of this... I have a script that does "Save As" but of course this prompts you to see if if you want to overwrite the file. Could someone give me some code or guidance on how I would make a macro that performs a "Save" upon leaving a cell?

    This sheet will be used by someone else that does not save his documents as often as he should... I am trying to avoid loosing data.

    Thanks for any help!
    Last edited by flipjarg; 07-12-2011 at 11:33 AM.

  2. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Re: Auto Save (in background/with no prompt) upon leaving cell... how?

    You can always try disabling alerts, running your code and then enabling the alerts again.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-14-2009
    Location
    Earth
    MS-Off Ver
    2007
    Posts
    43

    Re: Auto Save (in background/with no prompt) upon leaving cell... how?

    Awesome! Thank you for the help! Here is the code I ended up using in case anyone else can use it. Super simple... just saves the sheet when a cell is changed.

    Please Login or Register  to view this content.
    Last edited by flipjarg; 07-12-2011 at 11:34 AM.

+ 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