Solved: Force Hide Formula Bar

[zoom38]

Anyone know how to force hide the formula bar when an excel file opens? I have a file that has a somewhat long formula in cell A1 and when it opens it is rather annoying because the formula in A1 covers the first few rows. I realize that I can manually turn it off from the view menu but my file is for use by others who might have the formula bar on and don't know how to turn it off.

Thanks
Gary

[Bob Phillips]

[vba]

Private Sub Workbook_Open()

Application.DisplayFormulaBar = False
End Sub
[/vba]

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

[zoom38]

Thanks XLD works great.