Need Help

[Maithreya]

Hi. I have a workbook with more than 20 worksheets. And each sheet is having links to other sheets. Need VBA code to make all these links to values. Bored with conventional way of moving all sheets to new workbook and breaking links.
Any help is greatly appreciated. Thank you.

 

[Skyybot]

Try this:

Sub remHyperlinks()
Dim wb As Workbook, ws As Worksheet
Set wb = ThisWorkbook
For Each ws In wb.Worksheets
    ws.Cells.Hyperlinks.Delete
Next ws
End Sub