VBA to msgbox if opened from outlook

Flora Edwards
Flora Edwards used Ask the Experts™
on
I need help with VBA that If someone opens my workbook from Outlook then it should state that "workbook opened from outlook"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Rob HensonFinance Analyst

Commented:
Depending on your Trust Centre settings, files opened from an email will be opened in Protected Mode and Read Only, It may be possible to check that status and report when Read Only.
Civil Engineer
Commented:

Open in new window

If InStr(ActiveWorkbook.Path, "Content.Outlook") > 0 Then MsgBox ("Opened from Outlook")
Flora EdwardsMedicine

Author

Commented:
Kenneth Hobson

You are genius!

Thanks very much.  It worked perfectly.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial