Canceling Close

[JamesJoey]

Works fine now. I got to the point I did find the error number but wasn't sure how to apply it.

Thanks,
james

 

[JamesJoey]

Just wanted to say that everything is working great. I've been wanting to apply this for some time but never got around to it.
I want to say thanks to all.
Especially Pat Hartman for the assistance.

Thanks much,
James

 

[RickRo]

I was referred over to this thread - I have one question. Where does this go:

Public bPreventClose As Boolean

I think it would go to a a new module, but I cant seem to get it. When I add it by itself I get an error, if I add is as a sub I get an error, if I add it as a function I get an error.

Thanks!

 

[Gina]

Public bPreventClose as Boolean should be placed at the top of the module, NOT inside of a function.