Hello,
Im using below macro till kill all formula in my workbook.
Sub KillFormula()
Dim sh As Worksheet
Application.Calculation = xlManual
For Each sh In ActiveWorkbook.Worksheets
With sh.Cells
.Copy
.PasteSpecial xlValues
End With
Next sh
Application.Calculation = xlAutomatic
End Sub
However I would like to add hyperlinks for quicker navigation within the worksheets.
Is it possible to add some code so that cells that start with file:/// are excluded from the macro above? I'm a little bit worried that such code will slow down the excecution of the macro quite a bit though or what do you think?
Im using below macro till kill all formula in my workbook.
Sub KillFormula()
Dim sh As Worksheet
Application.Calculation = xlManual
For Each sh In ActiveWorkbook.Worksheets
With sh.Cells
.Copy
.PasteSpecial xlValues
End With
Next sh
Application.Calculation = xlAutomatic
End Sub
However I would like to add hyperlinks for quicker navigation within the worksheets.
Is it possible to add some code so that cells that start with file:/// are excluded from the macro above? I'm a little bit worried that such code will slow down the excecution of the macro quite a bit though or what do you think?