<div>
Thanks for the responses.<br />
<br />
<b>Matt,</b><br />
<br />
Your VBA Solution seems to be the best option as hiding formulas is not really the objective, just hiding the formula bar itself.<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----<br />
<br />
<b>Rob,</b><br />
<br />
Can you elaborate a bit? I don't understand your comment (eg &quot;that file&quot;).<br />
<br />
Thanks again
</div>


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

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Suppose you have multiple Excel (2013) workbooks open at the same time. <b>Is there a way to hide the Formula Bar in one of the workbooks without it also disappearing in the others?</b> <br />
<br />
Each of the other two items (gridlines &amp;&nbsp;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.<br />
<br />
Thanks
</div>
</div>


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

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.