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
|