[devonlady]

No help at all, I know but this thread brought to mind a dear old chap I cared for on the Milllelium eve.  Would you mind, asked the daughter as we are out all night, the dogs sleeping on your bed? Good Lord no, said I, they'd be welcome.
Well, one was an ancient lurcher who slept like a child, the other was a young Labrador with hip dysplasia and an unfortunate guarding tendency. Every time he heard a firework go off he was off the bed and barking madly at the window.
Silence, and he would come back to the bed and say, Well that has seen that off, err! could you help me back onto the bed please.
Dear old Dad slept all night and not a bit of trouble, but, my gosh, I earned my money that night with that lovely dog!!

[Marches Farmer]

A loud, firm, immediate "No" and the contents of a water pistol in the face can work wonders.

[SallyintNorth]

A loud, firm, immediate "No" and the contents of a water pistol in the face can work wonders.

lol, I've had three collie crosses - and a cat  - who loved to play-fight with a water pistol 

And on a serious note, I've seen no end of collie-owners at agility classes getting right royally chewed by their collies, who seemed to get more wound up and excited by being water-pistolled.