NIckH, james.

tested in Excel 2002 SP3, Win2K SP4. Macro Security = medium.

BTW James, which excel version are u using?


With Application
.AutomationSecurity = msoAutomationSecurityForceDisable
.Workbooks.Open "D:\Personal Data\book1.xls"
End With

Does not show a security promt, while there is a code module in the
workbook.

PS the bevaior if this settings changed slightly in excel 2003
(http://www.kbalertz.com/kb_825939.aspx)

DM Unseen