Office X Toolbars keep closing

[dholzer]

Is there a way to get the standard and formatting
toolbars to stay on the screen. Every once in a while, I
accidentally close them by clicking the square in the
upper left corner. I would like to get that square off of
the toolbar so I can't close them anymore. Please
help!

thanks,
Devin

 

[JE McGimpsey]

Is there a way to get the standard and formatting
toolbars to stay on the screen. Every once in a while, I
accidentally close them by clicking the square in the
upper left corner. I would like to get that square off of
the toolbar so I can't close them anymore. Please
help!

You can do this with VBA. Type OPT-F11 to enter the Visual Basic Editor
(or choose Tools/Macro/Visual Basic Editor).

Type CMD-G to open the Immediate Window. In the Immediate Window, type
or paste these line, followed by Return:

CommandBars("Formula Bar").Protection = msoBarNoChangeVisible
CommandBars("Standard").Protection = msoBarNoChangeVisible

If you'd like to prevent the bars from being moved from their docked
positions, add this to the end of each line:

+ msoBarNoChangeDock

Type OPT-F11 to return to XL. Close XL, then reopen.

This will persist until you delete your XL Toolbars (10) file in the
Preferences folder (or until you set the protection property something
else, like msoBarNoProtection).

 

[JE McGimpsey]

CommandBars("Formula Bar").Protection = msoBarNoChangeVisible
CommandBars("Standard").Protection = msoBarNoChangeVisible

Obvously I wrote these for XL, but the same thing will work in Word
(just change the toolbar names, where necessary)