View original (French)

Excel no longer asks me if I want to save

Laurie_IV Posted messages 14 Status Member -  
 Rob -
Hello everyone,
Here’s my problem: for a while now, when I close an Excel file, the program no longer asks me the classic question "Do you want to save?"

My issue is that I was used to saving only through that prompt. I obviously know how to save in other ways, but I found it faster to use that question. And above all, I just spent the whole day closing without saving. Grrrr... hard to shake off a habit!

Please help me. I’m going crazy!

Thanks in advance.

2 answers

  1.
    Babar64420 Posted messages 96 Status Member 3
     
    Good evening,

    It is possible that an Excel file was closed with a macro containing the line:

    Application.displayalerts=false

    Open Excel
    Go to the macro editor
    Insert a module, and type:

    Sub ResetAlertes()Sub ResetAlertes() Application.displayaletrs=True End sub

    Run the sub with the icon flanking the menu bar

    Close Excel and it should prompt you to save.

    Keep us updated

    Cordially
    1
    1. Babar64420 Posted messages 96 Status Member 3
       
      Ouch!

      Line Sub doubled and finger knots!!!

      Sub ResetAlertes()
      Application.DisplayAlerts=True
      End Sub

      It's better!

      Sorry...
      0
    2. Rob
       
      You just saved my week! thank you
      0
  2. Laurie_IV
     
    Hello,
    Thank you very much for your help but it seems that Excel fixed the issue by itself. Indeed, everything is back to the way it was before without any intervention on my part... Strange :)

    In any case, a big thank you for your response :)
    0