Ask Your Question

Hide toolbar in Calc file?

asked 2017-03-27 04:30:42 +0100

LibreGuy gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-27 07:47:07 +0100

Ratslinger gravatar image

updated 2017-03-27 07:49:20 +0100

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.

edit flag offensive delete link more


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?

LibreGuy gravatar imageLibreGuy ( 2017-03-27 16:11:09 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2017-03-27 17:45:29 +0100 )edit

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 :( Thanks for your help though.

LibreGuy gravatar imageLibreGuy ( 2017-03-27 20:01:06 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2017-03-27 20:05:32 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2017-03-27 20:10:14 +0100 )edit

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.

LibreGuy gravatar imageLibreGuy ( 2017-03-27 22:24:18 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-27 04:30:42 +0100

Seen: 133 times

Last updated: Mar 27 '17