OCX does not show on the form at runtime

Question

I have a macro that contains the GL2100 OCX (journal entry screen) 
 
 When run on site on a particular computer the form pops up , there is no error message but the ocx does not show at all 
 On the same computer, al macros that contain OCX have the same behaviour: form shows but the OCX does not show 
 I tried to design a macro with OCX from scratch on the "problem workstation" 
 When trying to draw any OCX on the form I get this error: &ldquo; the object is not trusted for the specified action&rdquo; 
 Thank you in advance for any suggestions you might have. Other computers at the same site can run the macros without issues and I have never seen this behaviour on any other workstation. 
 Ilona

IIAN · Answer

I found that this problem was caused by Excel settings which affect ActiveX controls across all applications using VBA 
Problem was solved by changing Excel Options/Trust Center Settings/ActiveX Settings and moving the checkmark from "Disable all controls without notification" to "Prompt me before enabling controls with minimum restrictions" 
The setting was also affecting field edit controls and datasource controls preventing them from showing on the form or from being added to the form (same error message as for OCXs)

Sage 300

OCX does not show on the form at runtime

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING