Norie and Tellm

Thanks for your responses.

I've done a bit more research on this and it seems that it's a known issue in excel 2010. This url gives details:

https://support.microsoft.com/en-us/kb/2745652

The KB article gives some sample code. My questions now are these: can the sample code be implemented as is or does it have to be customised for my own identifiers (workbook name etc); do the open and activate events code in the sample replace the standard Workbook_Open and Workbook_Activate events or do they have to be called explicitly?

Thanks in advance.

Iain