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

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

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

Look in the ThisWorkbook module for before_close and before_save

--
Don Guillett
SalesAid Software

"babyboos" wrote in message
...
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

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

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

"Don Guillett" wrote:

Look in the ThisWorkbook module for before_close and before_save

--
Don Guillett
SalesAid Software

"babyboos" wrote in message
...
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

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

Post your code here for comments

--
Don Guillett
SalesAid Software

"babyboos" wrote in message
...
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

"Don Guillett" wrote:

Look in the ThisWorkbook module for before_close and before_save

--
Don Guillett
SalesAid Software

"babyboos" wrote in message
...
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