Change in Hyperlink

[narendra1302]

Dear All,

When I copy a sheet from one file to another file, the hyperlink of a sheet is not operating. It shows the adress of old file & folder.

Is there any way to change the link of hyperlink (path can be changed).

Thanks
Narendra

 

[narendra1302]

Dear All,

Thanks - I have got the code in my earlier posts.

Thanks
Narendra