Hide toolbar in Calc file?

Recently I learned I could adjust a toolbar and save this adjusted toolbar in a (Calc) file. Nice!

So now when I open my Calc file, I only get to see the buttons that are necessary.

But now I’ve got a new question. For this specific file I don’t need the formula bar to be visible. Is there a way I can hide a complete toolbar and save that setting in my file as well? Or is that not possible?

Toolbars can be turned ON/Off through the menu - View->Toolbars. It is a toggle. Check mark indicates it is on. If you turn one off, it will remain that way until explicitly turned back on.

Thanks for your answer, but that was not exactly my question.

My question is if I can store a toolbar setting (visible/invisible) in a Calc file.

By default I want the formula toolbar to be visible, but for this specific file I want it to be invisible. Is it possible to store that setting (formula toolbar invisible) within the file itself?

Using a macro I can hide every toolbar displayed or specific toolbars except for the one you want. Also don’t see this specific toolbar in the Customize section.

Allright … I hoped it was possible without the use of a macro, by using the customize option only. But probably it’s not possible then :frowning: Thanks for your help though.

After some further investigation, it is probable to turn off the formula toolbar. However, any toolbar set to “hide” using macros can be turned back on simply by going back into the menu and clicking it back on. You would also need to modify the specific menu items to be disabled in order to prevent the user from turning it back on.

Forget the erased comment. My idea was to remove the item from the menu through customize. However, you can turn it back on from another document.

It’s not really a problem if you can afterwards enable the toolbar. The only thing I want is that when the file opens the toolbar is hidden. I would like to do that without using a macro, but unfortunately it seems impossible.