Solved

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

Posted on 2014-01-31
5
2,506 Views
Last Modified: 2014-02-28
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
Comment
Question by:Steve_Brady
  • 2
  • 2
5 Comments
 
LVL 35

Accepted Solution

by:
mvidas earned 300 total points
ID: 39825295
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
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 200 total points
ID: 39829026
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
 

Author Comment

by:Steve_Brady
ID: 39848768
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
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 200 total points
ID: 39848779
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
 

Author Closing Comment

by:Steve_Brady
ID: 39896372
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question