Links Braking Problem

Hi,
I have created one DashBoard and have to mail other recipients. Before sending mail I have to break the all links using below codes

Please Login or Register  to view this content.

This codes are working my other files but not working for one file. This file have lot of sheets (About 35). IS that the problem ?

Someone know any strong coed to break links pls help me

Thanks

Have you found the link that will not break?
Is it in the conditional formatting or the named ranges?

Have a look at data validation .. Named Ranges .. Hidden named ranges and delete any links
If you still face the problem attach sample of your workbook ...