This acts a toggle to show/hide formulas.

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



© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.