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