Locking Formula toolbar in the dock

[Kristina Conceicao]

I found some great code on JE McGimpsey's website that will lock the
Standard and Formula toolbars in the dock:
http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html

When I run the code, it does indeed prevent anyone from moving the
Standard toolbar (the Protection property is set to "msoBarNoMove"). It
also works well for other built in and custom toolbars. However, it
doesn't work for the Formula Bar. The code appears to run fine, but the
Protection property doesn't actually change. The immediate window says
it remains set at "22", which is "msoBarNoCustomize". Can anyone
confirm that I've run into a bug, or am I missing some crucial step?

Thank you!

 

[JE McGimpsey]

I found some great code on JE McGimpsey's website that will lock the
Standard and Formula toolbars in the dock:
http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html

When I run the code, it does indeed prevent anyone from moving the
Standard toolbar (the Protection property is set to "msoBarNoMove"). It
also works well for other built in and custom toolbars. However, it
doesn't work for the Formula Bar. The code appears to run fine, but the
Protection property doesn't actually change. The immediate window says
it remains set at "22", which is "msoBarNoCustomize". Can anyone
confirm that I've run into a bug, or am I missing some crucial step?

It works as advertised for me for XLv.X and XL04.

In addition, msoBarNoCustomize = 1, not 22, which would indicate the
logical OR of msoBarNoChangeDock, msoBarNoMove, and msoBarNoResize.

Your Formula Bar may have become corrupted. With XL closed, try moving
or deleting the

~:Libraryreferences:Microsoft:Excel Toolbars (11)

file (the 11 will be 10 for XLv.X), where "~" is your Home directory.

 

[Kristina Conceicao]

It works as advertised for me for XLv.X and XL04.

In addition, msoBarNoCustomize = 1, not 22, which would indicate the
logical OR of msoBarNoChangeDock, msoBarNoMove, and msoBarNoResize.

Your Formula Bar may have become corrupted. With XL closed, try moving
or deleting the

~:Libraryreferences:Microsoft:Excel Toolbars (11)

file (the 11 will be 10 for XLv.X), where "~" is your Home directory.

Thank you so much - trashing the toolbar pref did the trick. Now I'm
getting the correct values in the Immediate window for the various
Protection properties, and the code locks down the Formula bar as expected.

Sorry I forgot to mention that I use Excel 2004 - what a rookie mistake!!

Thanks again,

Kristina