Asif Shah wrote:
Thanks. But there was nothing in the Hyperlink base field. It was blank.

Exactly.
That's why you have the problem and why I suggested you fill it with some
non-existent location such as \\NoServer\NoFolder.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup