View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_28_] gocush[_28_] is offline
external usenet poster
 
Posts: 42
Default message when activating OLE object

does this work?
Application.DisplayAlerts=False

"Tony" wrote:

I have added the help file to my template as a PDF OLE Object which is
displayed by calling the simple procedure executing the following statement:

Worksheets("HelpSheet").OLEObjects("HelpFile").Act ivate

On execution of the macro the following warning statement is displayed:

You are about to activate an OLE object that may contain viruses or may
otherwise be harmful to your computer. You may want to verify that this
object comes from a trustworthy source before you continue
Do you want to continue ?

Is it any way to skip this warning message and open the PDF file ?

Thanks for help.