Removing Sharperlight formulas using VBA

​
If you are sending a Excel Workbook to someone how does not have the Sharperlight Add-in installed, first click the Detach Formulas button on the Toolbar.  This will leave all the values in the sheets but remove the formulas so that #NAME does not appear.

It is also possible to remove the formulas from VBA

Sub RemoveSharperLightFormulas()

”Application.DisplayAlerts = False

”Application.Run “mdConvertmdFormulaToValueWithPrompt”
 
Application.Run “mdConvertmdFormulaToValue”

End Sub