how can i disable my spreadsheet to stop executing macros when i open the worksheet ?

like the security notice will popup, asking me if i want to include macros or not....i click yes, and macros execute immediately....


even tho i put

 Workbook_Open()

'clear all formula fields

end sub

isn't that supposed to make sure no formula gets filled in, and that no macros execute ?

You can try the following:

Sub Security()
    Dim secAutomation As MsoAutomationSecurity

    secAutomation = Application.AutomationSecurity

    Application.AutomationSecurity = msoAutomationSecurityForceDisable

    Workbooks.Open "c:\temp.xls"

    Application.AutomationSecurity = secAutomation

End Sub

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)