Macro to auto-update links

Are there a few lines I could add to this code to auto update links when sheet is opened? I found a way to promt user to update but they still have to click the update button.

Please Login or Register  to view this content.

Good afternoon jcranst

Originally Posted by jcranst

Are there a few lines I could add to this code to auto update links when sheet is opened?

No there aren't. This is a security feature, so the user can't be forced to update links or run macros through VBA.
You will have to persuace your users to accept all links through the Trust Center , or set up the directory where the file resides as a trusted location (again, through the Trust Center).

HTH

DominicB