Window.DisplayFormulas (Excel)

True if the window is displaying formulas; False if the window is displaying values.

This property applies only to worksheets and macro sheets.

ActiveWindow.DisplayFormulas = True