Hi All

I'm trying to open a workbook without running the workbook events. I have created a SetSecurity modification to 3 (ForceDisable). This then opens the workbook without executing the workbook_open events

The problem that I'am having now is that when I pass the workbooks.open(""), it looses control of the workbook & doesn't continue with the rest of the script

I have tried setting a Workbook variable during the open, without luck. Opens the file fine, but I need it to contiue with the code

I have even tried Application.EnableEvents = False, then opening the wb without the change to the security setting

Any help on this one would be great

Paul