LinkBack URL
About LinkBacks
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
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
Last edited by diddy47; 09-25-2019 at 04:29 PM.
Hello diddy47,
You may try;
Regards.
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
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?
You need to place the code in the ThisWorkbook module?
HTH
Regards, Jeff
thanks for pointing that out it works now
@ 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.
@Winon,
Happy to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks