Hi Greg,

it works for me i.e. I don't need to close the workbook. Just toggle
between two workbooks and it updates.

I'd try checking your event is still firing - maybe you were tinkering
and crashed out of your code, that's normally enough to stop your app
level events firing.

If not that, maybe something is interfering with it? I'm using XL2003
SP1 btw.

Gareth

GregR wrote:
Gareth, you're right I don't get the full path, but I have save the WB,
even closed it and reopened it, still no full path.

Greg