Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Message to Spreadsheet
When the user clicks on the OK button you need to add the xldialogsendmail ... ie. ans = msgbox("What you want to say", vbyesno) if ans = vbyes then Application.Dialogs(xlDialogSendMail).Show "), "NameofDocument" end if *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Message to Spreadsheet
Thank yo for your assistance, that is just what I needed
-----Original Message----- When the user clicks on the OK button you need to add the xldialogsendmail ... ie. ans = msgbox("What you want to say", vbyesno) if ans = vbyes then Application.Dialogs(xlDialogSendMail).Show "), "NameofDocument" end if *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message when adding a name | Charts and Charting in Excel | |||
Adding the message body to a mailto macro | Excel Discussion (Misc queries) | |||
Adding message window | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
can I add a flashing message to a spreadsheet? | Excel Worksheet Functions |