how do i get a pop up message on saving or exiting a document?

B

babyboos

i know i have done this before but can't remember how today
when i close a document i want it to pop up a message telling the user to
remember to password protect the workbook first
i then want it to ideally not let them save until the workbook is password
protected or if easier automatically password protect on exiting
failing this just at least warn them and if they choose not to it is their
look out
 
B

babyboos

Hi yes they look familiar
but I must be missng something as I have copied the code into ThisWorkbook
and the prompts don't appear when I hit the save button or go file/exit
 
Top