View original (French)

Pop-up Window When Opening an Excel File

Solved
GillesBouchard Posted messages 11 Status Member -  
GillesBouchard Posted messages 11 Status Member -
Hello,

I would like to create a pop-up reminder (a window) when opening an Excel document (like "Don't forget to save the file under a different name before using it").

Does anyone know if this is possible?

Configuration: Windows XP / Safari 534.10

2 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Good evening 

    Private Sub Workbook_Open() MsgBox ("don't forget ...") End Sub


    to put in the code associated with the Workbook
    to access it press Alt F11 then select ThisWorkbook in the project sheet

    have a nice continuation
    17
  2. GillesBouchard Posted messages 11 Status Member 1
     
    Thank you very much, it's great!!
    1