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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Look in the ThisWorkbook module for before_close and before_save
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Providing user message when RED X clicked & properly closing application. 2
How do I remove a forgotten password from an Excel Worksheet? 2
Macros 1
password protecting cell in a protected file that are not protecte 1
How can I suppress the enable macros and save changes messages? 4
How I unprotect my workbook if I failed to remember my password 2
How do i protect specific cells in a shared workbook? 1
Message Box on exiting workbook 1

Back
Top