VBA check enable content with code

[FryGirl]

I have found some code to open each workbook in a folder and copy range X:X.

The code works great, but for the approximately 8 workbooks the code is grabbing the data from, I have to click Enable Content 8 times.

Since I can't alter any of the settings in the Trust Center, is it possible for a macro to suppress the Enable Content feature when retrieving data from workbook?

 

[FryGirl]

Any thoughts?

 

[RoryA]

If it's to enable macros, you can use Application.AutomationSecurity to bypass that.

 

[FryGirl]

Thanks Rory. I'll give that a try.