With VBA we set DisplayAlerts=.f., But have no idea how the OCX OLE would let you manage this.
>Hi All,
>
>I Have an OLDBound Control in my form which I LINK to a Word,Excel or PowerPoint Documents. The Control is bound to a General Field.
>The Problem is when the control is Linked to an EXCEL SpreadSheet which uses Macros, each time when I get the record (using Next/Prev on my toolbar) I'm getting a message from the OLE (Excel)server 'The document you are opening contains macros...etc'.
>How can I get rid of this message and make it apears only when the user DubleClicks on the Control, and not when the user is browsing the table using Next/Prev.
>
>Please Help!
>
>TIA.
>
>Shlomo :)