Hi all,

General niggling point, ive tried to use cancel=true to stop things
happening (like close event and so on) but it always just carried on
and closed/saved/whatever. I just got a little wound up and found ways
around it and then forgot all about it till recently...I tried it on
another pc (one round a friends house) and noticed that it
worked.......strange....

Does anyone know why this is intermittent?

Duncan

Duncan, since no one else is answering this, I'll give it a shot. Put
a breakpoint on your line of code that is supposed to cancel by
clicking on the gray area to the left of it. If the code doesn't break
when you run it, then execution is not reaching that point. If it does
break and you debug, you should be able to rest the cursor over your
variables and get values for them. Might be a starting point.
James
Duncan wrote:
Hi all,

General niggling point, ive tried to use cancel=true to stop things
happening (like close event and so on) but it always just carried on
and closed/saved/whatever. I just got a little wound up and found ways
around it and then forgot all about it till recently...I tried it on
another pc (one round a friends house) and noticed that it
worked.......strange....

Does anyone know why this is intermittent?

Duncan

Duncan,
It does work, but for some reason the code is not being executed as you
think.
Follow James' advice to see if the events is being fired.

If not, the run
Application.EnableEvents=true
and try again.

NickHK

"Duncan" wrote in message
oups.com...
Hi all,

General niggling point, ive tried to use cancel=true to stop things
happening (like close event and so on) but it always just carried on
and closed/saved/whatever. I just got a little wound up and found ways
around it and then forgot all about it till recently...I tried it on
another pc (one round a friends house) and noticed that it
worked.......strange....

Does anyone know why this is intermittent?

Duncan

Thank you Nick and James for your suggestions,

I will have a go at seeing which events are not being fired through
debugging, Ive noticed that depending on whether I close through my
form or through Excel the workbook_close event doesnt always fire, I
will look into it......

Many thanks

Duncan





NickHK wrote:

Duncan,
It does work, but for some reason the code is not being executed as you
think.
Follow James' advice to see if the events is being fired.

If not, the run
Application.EnableEvents=true
and try again.

NickHK

"Duncan" wrote in message
oups.com...
Hi all,

General niggling point, ive tried to use cancel=true to stop things
happening (like close event and so on) but it always just carried on
and closed/saved/whatever. I just got a little wound up and found ways
around it and then forgot all about it till recently...I tried it on
another pc (one round a friends house) and noticed that it
worked.......strange....

Does anyone know why this is intermittent?

Duncan