Just before you open the workbook, then reset afterwards.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matty S" wrote in message
...
Thanks Bob
But where do i put thate code, under worbooks open?