On Feb 2, 9:18*pm, Terry wrote:
On Feb 2, 8:41*pm, Tim Williams wrote:

Why use workbook_activate rather than workbook_open ?

Not sure that would fix your problem but worth a try...

Tim

Actually, it is on open and not activate.

Wherever it is, it only exhibits this bizarre behavior if there is at
least one other workbook open.

Hard to suggest anything without seeing actual code.

Tim