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

Answer 1 / 2
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
Answer 2 / 2
GillesBouchard Posted messages 11 Status Member 1
 
Thank you very much, it's great!!
1