Enable ActiveX control Option in Trust Centre

K

K

Hi all, I am using excel 2007 and I know to enable ActiveX control
option on sheet you need to go to tick box in Trust centre but my
question is that is it possible to enable ActiveX control option by
macro as I got ActiveX controls on my sheet and I have to send that to
other colleagues by email and i dont want them all to go and enable
this ActiveX control option in Trust centre. I want a macro that when
they open this Workbook then ActiveX control option automatically get
enable. Please can any friend can help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
How to enable "enable automatic update" security setting by VB cod 0
Quicker way to enable macros? 3
ActiveX control security 3
Menu Macro Not Executing - Need Help 1
Read MHT file using macro 0
Moving an ActiveX control 0

Top