Always enable macros and never update links when opening

[cjcobra]

I currently use a file many times and 99% of the time I want to enable the macros and 99% of the time I don't want to update the links. Is there a setting or macro I could put into the file that would do this for me so I don't have to EVERY time. If so, how to turn either one off if ever needed?

Thanks...

[Damon Ostrander]

Hi cjcobra,

Yes, you can do both of these things. To always enable macros, just set your security settings to low (Tools -> Macro -> Security). Of course, this will make you somewhat vulnerable to macro viruses, so you should be in a very trusted environment to do this. If you only want change your security settings for a particular file, put the security back to medium and add a digital certificate (or whoever generated the workbook should do this) so that the enable macros step can be skipped for this file.

Regarding updating the links, this is set from the Tools -> Options -> Calculation tab -> uncheck update remote references.

[jg1284]

Following up on this question:

Is there a way to control how your macro opens another workbook? I want to cycle through about 1,000 workbooks, opening, pulling simple information (e.g., tab names), then closing, but many of these workbooks have external links and password protection.

When my workbook has "Update Remote References" unchecked the password prompt still comes up from the other file I am opening.

Basically, I want my macro to cycle through all these files without bothering me with any prompts, I really don't care if links are updated or not as the files are read-only anyway, but I don't have the password so don't know how to get rid of these prompts.

I already include "Application.DisplayAlerts = False" in my code, and I tried using "xlUpdateLinksNever" which prevents the update links prompt, but instead brings up the password prompt and then another prompt to leave the workbook "as is".

Any help would be greatly appreciated. Thanks.