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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.