You should at least set Cancel to True.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alan McQ via OfficeKB.com" <u22393@uwe wrote in message
news:61b76a549afba@uwe...
Bob Phillips wrote:
Did you save it in the ThisWorbook code module?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hello,

[quoted text clipped - 31 lines]

Any help would be much appreciated
Bob,

Apologies, this is included in the ThisWorkbook code module

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1