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

Similar Threads

Need Help with Macro Security 1
Quicker way to enable macros? 3
VBA code won't run, even with Macro Security set to Enable All Macors 9
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Macro-enable Workbook 0
Stumped - Problem with Macro Security settings? 10
Why does excel sometimes not ask to enable macros (medium security 1
Macros disabled, not by security settings? 9

Top