View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pam pam is offline
external usenet poster
 
Posts: 11
Default Adding Message to Spreadsheet

I want to add a message to users that activates when the
user goes to: TOOLS -- Protect.

Presently the pages are protected, however, users can
unprotect (with a user password) to change specific
formulas. I need to monitor what formulas are being
changed. Would like to have user send e-mail specifying
this information. How do I add the message box. I
attempted it in a Macro as follows:

MsgBox ("You must send e-mail to AFMA/MAP indicating
which cells are being changed"), vbExclamation, vbOK

Any assistance will be appreciated. Thanks