Paul, I'm afraid I can't understand that solution and I don't think it will work for us for the following reason - we hyperling from Word to other Word documents but also to Excel documents and from Excel documents. The links don't all go to one document so I'm not sure the macro will work - or am I missing it all together?