Results 1 to 2 of 2

Thread: Prompting to save not working
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2012
    Posts
    240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Prompting to save not working

    Hi,

    In one of my workbooks, if I try to save it after changes, I am not prompted. The workbook just closes. There are no macros in the workbook.

    How can I turn the prompt back on? I close the workbook and it just closes which is annoying.

    Thanks

  2. #2
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Location
    Bulgaria, GMT+2 (42.891813,25.313594)
    Posts
    1,281
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Prompting to save not working

    Check if Alerts are ON.
    Start VBE (Alt+F11)
    Go to Immediate window (Ctrl+G)
    type the following and Press Enter: ?Application.DisplayAlerts
    if the result is FALSE then type the following and press Enter: Application.DisplayAlerts=True

    The other option is to check in the same way if the Workbook has already been saved somehow before closing it.
    ?ThisWorkbook.Saved
    If the result is True then the workbook has already been saved somehow and no prompt to save will popup.
    Last edited by bobsan42; Feb 22nd, 2019 at 03:49 AM.
    "...it's sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 +10 (64-bit) / excel 2013 +2016 (32-bit) / access 2013 +2016 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •