PDA

View Full Version : Solved: Force Hide Formula Bar



zoom38
06-07-2008, 05:32 AM
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
06-07-2008, 05:46 AM
Private Sub Workbook_Open()

Application.DisplayFormulaBar = False
End Sub


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
06-07-2008, 11:03 AM
Thanks XLD works great.