How to enable "enable automatic update" security setting by VB cod

A

arun

Hi All,

I wanted to enable "enable automatic update for all workbook links" radio
button through VB code (macro),
As my current macro code gets link references from other excel workbook, so
it is important to enable this setting by code itself.

Default location of thatradio button is Excel Options-->Trust Centre-->Trust
Center Settings-->External Content.
 

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

Top