View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default Enable ActiveX control Option in Trust Centre

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.