Disable macro's in opening Excelsheet

[HWijngaarD]

Is there any way to open an Excelsheet in code without enabeling the macro's?
Dim WB as WorkBook
Set WB = Application.Workbooks.Open("filename.xls")

[billhuard]

take a look at the automationsecurity property

should be something like

Application.AutomationSecurity = msoAutomationSecurityForceDisable

[Radjesh Klauke]

Well you could also set the security to "very high"

[billhuard]

True, but if he does that, I think he won't be able to run the macro that opens his new workbook...

[Radjesh Klauke]

That is the problem indeed.

[HWijngaarD]

msoAutomationSecurityForceDisable is a 2003 thing
And I ain't got 2003.

By the way, I don't need the macro's in the sheet.
The problem is, if I open the sheet witch contains macro's, the macro from which I open the sheet stops immediately after opening the sheet.
Got it?

[billhuard]

By the way, I don't need the macro's in the sheet.

If you don't need the macro at all, why don't you just delete it.
And if you need it for further uses, place them in a module.

I don't think you can disable macro for only one sheet, you disbale it for the whole workbook. So this is why you got this problem:

The problem is, if I open the sheet witch contains macro's, the macro from which I open the sheet stops immediately after opening the sheet.

[DKenny]

IF all of these are Event Macro, like Worksheet_Change(ByVal Target As Range), etc.

The you can disable them by calling "Application.EnableEvents = False"

Make sure you turn events back on when your done.