Closed Thread
Results 1 to 2 of 2

Why "do you want to save" messagebox prompted?

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Warsaw, poland
    MS-Off Ver
    Excel 2010
    Posts
    77

    Why "do you want to save" messagebox prompted?

    All,

    I have a question about preventing "Do you want to save" message box to prompt. Well, most cases are covered by workbook.saved property, however not the one when the user is rushed to switch off or restart pc when the file is open.

    Do you know any simple way of dealing with that?

    Thanks in advance.

    You can test the issue with a rather simple code (to be included ThisWorkbook module).

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Why "do you want to save" messagebox prompted?

    It's not clear (at least to me, what it is you're trying to achieve.

    Can you describe the processes you undertake and what results you expect.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to select "yes" when prompted to check in sharepoint file using VBA
    By Spartangirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 12:32 PM
  2. Code only runs when a user hits "Save", not "Save As"
    By cjstewart8 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2014, 07:41 PM
  3. [SOLVED] Script to save to folder in "v:\dept2", confirm file saved, then delete from "v:\dept1"
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2014, 11:42 AM
  4. [SOLVED] Cancelling "Open" dialog box when prompted macro
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 01:17 PM
  5. Macro to select "Continue" when opening another file and prompted to update links
    By kwaldersen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2012, 11:57 AM
  6. Validation on clicking "Cancel" on messagebox.
    By excelit in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-02-2011, 08:32 AM
  7. Excel Sort Macro is just giving me a "400" messagebox!
    By gausie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2007, 06:32 AM

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