Hi Bob,

You just knew I'd be back ;)

I tried many variations of Thisworkbook, and to be honest had a nightmare.

In the end I've settled for the first line in the timed code to be

ThisWorkbook.Activate

At least this gives the relevant workbook focus to run the code ok.

At the moment I'm happy with this until I find alternate usage of
ThisWorkbook

My main aim was to run the code in the background without having to give
the workbook focus, I'm sure this is possible but at the moment it's
stumping me.


Ron