VBA Excel how to emove drop down from custom toolbar?

[ConieFL]

I have and excel spreadsheet with a custom toolbar. On the end of the custom tool bar is a down arrow for a pull down menu which displays
'Add or Remove Buttons'

Is there a way not to display the 'Add or Remove Buttons' drop down on a user created custom toolbar?

[ubentook]

You can protect the toolbar to prevent the adding or deleting of buttons ...

MyBar.Protectio n = msoBarNoCustomi ze

Maybe that will suit your needs.

[ConieFL]

Thank you I will give it a try.