......No error message is received either!
The code hits the following line:

Sheets("xxx").Copy

....then a couple of events are fired and the event code runs.
As soon as the last End Sub of the event code has run, instead of the
macro going back to the original routine it just stops!

This is sprecific to my colleagues machine (application.enableevents
is set to Tue on both machines)

Anyone got any ideas?

Any help appreciated,
J.

does your colleague have any user defined function used in the worksheet.
These could be causing the problem.

Also, no workbooks begin opened with a macro that uses a shortcut key
combination that includes the shift key?

--
Regards,
Tom Ogilvy


"WhytheQ" wrote:

......No error message is received either!
The code hits the following line:

Sheets("xxx").Copy

....then a couple of events are fired and the event code runs.
As soon as the last End Sub of the event code has run, instead of the
macro going back to the original routine it just stops!

This is sprecific to my colleagues machine (application.enableevents
is set to Tue on both machines)

Anyone got any ideas?

Any help appreciated,
J.

Thanks for getting back to me Tom.
Neither of us have any User Defined Functions set up.
I wrote the macros and haven't actively set any short cut key
combinations - do these get set automatically?
Thing is Tom even if I use Application.enableevents = false so that
none of these auto_open macros fire it still just stops half way
through !!
Have you ever seen anything like htis before? ... Any ideas on a
possible workaround ?

Thanks for your help thus far: any further help is appreciated.
J

On 21 Feb, 17:30, Tom Ogilvy
wrote:
does your colleague have any user defined function used in the worksheet.
These could be causing the problem.

Also, no workbooks begin opened with a macro that uses a shortcut key
combination that includes the shift key?

--
Regards,
Tom Ogilvy



"WhytheQ" wrote:
......No error message is received either!
The code hits the following line:

Sheets("xxx").Copy

....then a couple of events are fired and the event code runs.
As soon as the last End Sub of the event code has run, instead of the
macro going back to the original routine it just stops!

This is sprecific to my colleagues machine (application.enableevents
is set to Tue on both machines)

Anyone got any ideas?

Any help appreciated,
J.- Hide quoted text -

- Show quoted text -

Have I seen it. Yes.

Is it one particular thing that causes it - no.

--
Regards,
Tom Ogilvy


"WhytheQ" wrote:

Thanks for getting back to me Tom.
Neither of us have any User Defined Functions set up.
I wrote the macros and haven't actively set any short cut key
combinations - do these get set automatically?
Thing is Tom even if I use Application.enableevents = false so that
none of these auto_open macros fire it still just stops half way
through !!
Have you ever seen anything like htis before? ... Any ideas on a
possible workaround ?

Thanks for your help thus far: any further help is appreciated.
J

On 21 Feb, 17:30, Tom Ogilvy
wrote:
does your colleague have any user defined function used in the worksheet.
These could be causing the problem.

Also, no workbooks begin opened with a macro that uses a shortcut key
combination that includes the shift key?

--
Regards,
Tom Ogilvy



"WhytheQ" wrote:
......No error message is received either!
The code hits the following line:

Sheets("xxx").Copy

....then a couple of events are fired and the event code runs.
As soon as the last End Sub of the event code has run, instead of the
macro going back to the original routine it just stops!

This is sprecific to my colleagues machine (application.enableevents
is set to Tue on both machines)

Anyone got any ideas?

Any help appreciated,
J.- Hide quoted text -

- Show quoted text -