"K Dales" wrote in message
...
ThisWorkbook will always refer to the active workbook.

Nope. It will always refer to the workbook containing the macro.

--

Vasant