How to Hide Formula Bar For One Excel File Only

[diddy47]

Hello

I am looking to hide the formula bar on a specific excel file.
What I found in setting turns it off for all excel files

I am guessing this can be achieved with code?

is it possible?

Thank you

[Winon]

Hello diddy47,

You may try;

Please Login or Register  to view this content.

Regards.

[diddy47]

Maybe i am not implementing this correctly

I placed this code in the area found after right click view code on the tab

I placed the code at the very top of the box and closed the MVBA box and saved the file then closed the file

According to what I can understand from the code above from now after each time I open the file the formula bar will not appear....this is true for any excel file opened whilst THIS file is open as well. And when i close this file the formula bar should re-appear on all other open excel files and any other i open thereafter. unless i am very much mistaken

The code does not seem to behave this way. Nothing seems to be happening. I am sure I missed something and missed a step somewhere?

[jeffreybrown]

You need to place the code in the ThisWorkbook module?

[diddy47]

thanks for pointing that out it works now

[Winon]

@ jeffreybrown,

Hello Jeff,
Thank for filling in my neglect to state that the Code should be placed in the ThisWorkbook module.

@ diddy47,

Thank you for the feedback, and the Rep+. I appreciate it.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

[jeffreybrown]

@Winon,

Happy to help!