Results 1 to 11 of 11

How to stop the "Save As" warning

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    22

    How to stop the "Save As" warning

    Hi all..


    How can I get rid of the warning - Do you want to save the changes you made to 'hb.xls'? when I try to close the work book?


    Have tried each of the following with no luck

    WBSN.Activate
        
        WBSN.Close savechanges:=False
    WBSN.Activate
        
        WBSN.Close savechanges:=True
    ThisWorkbook.Saved = True
         ActiveWorkbook.Close
    ThisWorkbook.Saved = True
         ActiveWindow.Close
    Thanks in advance
    Last edited by heathbo; 09-13-2013 at 09:42 AM. Reason: extra code added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to stop warning message in Excel "initialize ActiveX controls"
    By Sya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2006, 05:20 AM
  2. Stop "save changes" message appearing
    By DJ Dusty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 10:42 AM
  3. [SOLVED] Stop users from accessing "Protection" option from "Tools" menu
    By I Believe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2005, 10:50 AM
  4. [SOLVED] Stop "Save as" and Copy File
    By maperalia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2005, 01:05 AM
  5. How do I stop the "do you want to save changes" prompt using VB code
    By john928 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2005, 12:05 PM

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