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

Hi Paul,
Did you assign the workbook to be open to a variable ?
Like : Set wb = Workbooks.Open(strWorkbookToOpen)
Reeards,
JY
"Paul Mac." wrote in message
...
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