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