This acts a toggle to show/hide formulas.

Sub ShowFormulas()
 ActiveWindow.DisplayFormulas = Not ActiveWindow.DisplayFormulas
End Sub



© Copyright andrewsexceltips.net All Rights Reserved.