Preliminary Documentation for smfFixLinks-Macro



There was no documentation found for the SMFFixLinks Macro so I will add this to the TO-DO list.

I have always had the smfFixLinks-Macro in my own personal macros and then have a shortcut on my menu bar to access both it and the Force Recalculation macro. This allows me to run them quickly and also resolves when on occasion the add-in doesn't appear when first opening a new workbook. Here is the macro if you want to copy it to your own personal macros:

Public Sub smfFixLinks()
   Dim Sht As Worksheet
   For Each Sht In Worksheets
     Sht.Cells.Replace _
       What:="'*\RCH_Stock_Market_Functions.xla'!", _
       Replacement:="", _
       LookAt:=xlPart, _
       SearchOrder:=xlByRows, _
       MatchCase:=False, _
       SearchFormat:=False, _
       ReplaceFormat:=False
     Next Sht
   End Sub

... to be continued.