DisplayFormulas Property Example
This example changes the active window in Book1.xls to display formulas.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.DisplayFormulas = True