• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3090
  • Last Modified:

Hide the Excel Formula Bar in only one of multiple open workbooks

Hello,

Suppose you have multiple Excel (2013) workbooks open at the same time. Is there a way to hide the Formula Bar in one of the workbooks without it also disappearing in the others?

Each of the other two items (gridlines & headings) under the View menu can be changed in only a single workbook but I cannot determine how to do the same with the Formula Bar.

Thanks
0
Steve_Brady
Asked:
Steve_Brady
  • 2
  • 2
3 Solutions
 
mvidasCommented:
Hi Steve,

The visibility of the formula bar is application-level, meaning you can't inherently give it different settings for different workbooks.

If you're willing to use macros, however, we can accomplish what you want. Press Alt-F11 to open the VBA editor, then press control-r to open/focus on the Project window. Look for the workbook you want it to be hidden in, and expand the "Microsoft Excel Objects" folder. Double click the "ThisWorkbook" icon, and in the codepane that appears, paste in the following:
Private Sub Workbook_Activate()
 Application.DisplayFormulaBar = False
End Sub

Private Sub Workbook_Deactivate()
 Application.DisplayFormulaBar = True
End Sub

Open in new window


An alternate approach without macros would be to hide your cell values/formulas and protect the sheet. This hides the formula from showing up in the formula bar.
Select your cells, press control-1 to open the Format Cells window, and go to the Protection tab. Check the box for Hidden, and press OK. Then, protect the worksheet. The formula bar will be blank for the Hidden cells.

Matt
0
 
Rob HensonIT & Database AssistantCommented:
If you force that file to open a new instance of Excel it will have its own formula bar to hide.

Thanks
Rob H
0
 
Steve_BradyAuthor Commented:
Thanks for the responses.

Matt,

Your VBA Solution seems to be the best option as hiding formulas is not really the objective, just hiding the formula bar itself.

------------------------------------------------------------

Rob,

Can you elaborate a bit? I don't understand your comment (eg "that file").

Thanks again
0
 
Rob HensonIT & Database AssistantCommented:
Open a separate instance of excel by running the shortcut from the start menu and in the new instance of excel open the file for which you want to hide the formula bar.
0
 
Steve_BradyAuthor Commented:
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now