+ Reply to Thread
Results 1 to 2 of 2

Only "save" option in save prompt while closing excel sheet

  1. 09-30-2013, 06:33 PM #1
    rudswa
    rudswa is offline
    Registered User
    Join Date
    05-27-2013
    Location
    BANGALORE, INDIA
    MS-Off Ver
    Excel 2013
    Posts
    45

    Question Only "save" option in save prompt while closing excel sheet

    Please can anybody explain how to have only "SAVE" option in the save prompt while closing macro enabled excel sheet using VBA code.

    Thanks
    Reply With QuoteRegister To Reply
  2. 09-30-2013, 08:07 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Only "save" option in save prompt while closing excel sheet

    Hi Rudswa,

    You can omit the prompt and save automatically: 
    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Force "Save As" in Prompt Before Close - X Button
    By RodrigoTomaz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2013, 02:00 PM
  2. No "Save prompt" on closing Excel
    By Kevpat in forum Excel General
    Replies: 5
    Last Post: 09-12-2012, 06:06 AM
  3. VBA. save Shared workbook. not to prompt "conflict" message if its to do with cell x,y,z
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2012, 11:09 PM
  4. Disabling "SAVE AS" option under "File"
    By Bidyut Bhattacharjee in forum Excel General
    Replies: 3
    Last Post: 03-22-2006, 02:40 PM
  5. [SOLVED] excel 02 always asks "save changes?" when closing unaltered file
    By 6foot6 in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 03:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1