Add custom toolbar name to ‘customize’ menu (Win XP SP2 – XL2003 UK)

Topic

New Reply

Hi,

Got a custom toolbar that can be selected from Tools -addins menu.
However it is not shown in the ‘Tools’ – ‘Customize’ – ‘Toolbars’ list of available and checkable toolbars.

My question is – what do I have to do to have my custom toolbar displayed in the list…?

THX!

Reply | Quote

Replies

When you drag the custom ToolBar down from the Toolbar area onto the Worksheet area the Toolbar’s name will appear in the Title area of the toolbar. Are you certain this name (not the caption) does not appear near the bottom of the list?

Reply | Quote

Maybe the custom toolbar is “protected”. Don’t know much about Excel, but in Word it’s possible to hide a toolbar from the list in Tools – Customize – Toolbars, with one line of VBA code:

ActiveDocument.Commandbars(“MyBar”).Protection = msoBarNoChangeVisible

To make it visible again, just use:

ActiveDocument.Commandbars(“MyBar”).Protection = msoBarNoProtection

I wouldn’t be surprised if something like this is possible in Excel.

Reply | Quote

Hi Jan
In Excel it’s exactly as you described.

Reply | Quote

Thanks for the confirmation Don.

Reply | Quote