Not by changing it to

set thisWB = ThisWorkbook

as that only works on the workbook that the code is in, whereas that
variable will point at the next opened workbook.

Are you sure?

--

HTH

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

"pauluk " wrote in message
...
ok got it work at last!!!! woo


---
Message posted from http://www.ExcelForum.com/