Barb,

Wouldn't this affect my main file macros? I need to open the second file
with macros inactive... will below do it and still keep my master file macros
active. Please calrify.

"Barb Reinhardt" wrote:

Put this around your workbook open code

Application.AutomationSecurity = msoAutomationSecurityLow
'Workbook open code
Application.AutomationSecurity = msoAutomationSecurityByUI

HTH,
Barb Reinhardt

"Alberto Ast" wrote:

I need to open a file read only and macros inactive.

I know how to do read only but how to do macros inactives?