I have developed an application with custom toolbars. At the end of my
toolbar Excel adds a drop down 'Tool Bar Option' that lets the user customize
the toolbars. Whilst I have set my custom bar option to no customise, the
user can still create a new toolbar and add their own controls!

Is it possible to disable this drop down or is there some other way to
prevent the user from accessing the customize toolbar options?

Many thanks

You would just set the Enabled property of the control to False. You access
the control either via a control variable that you setup when you add the
control, or via CBname.Controls(control_caption) object.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nigel RS" wrote in message
...
I have developed an application with custom toolbars. At the end of my
toolbar Excel adds a drop down 'Tool Bar Option' that lets the user
customize
the toolbars. Whilst I have set my custom bar option to no customise, the
user can still create a new toolbar and add their own controls!

Is it possible to disable this drop down or is there some other way to
prevent the user from accessing the customize toolbar options?

Many thanks

Hi Bob
Thanks for the reply. I understand the setting of the controls I set up in
my toolbar but this is a control set by Excel. Not sure what it is called
other than when you click it, it shows 'Toolbar Option' with a further menu
showing 'Add or Remove Buttons' then my Bar which is disabled and 'Customize'
- it is from here that users can create their own toolbar.

Hope this makes sense?

Cheers
Nigel

"Bob Phillips" wrote:

You would just set the Enabled property of the control to False. You access
the control either via a control variable that you setup when you add the
control, or via CBname.Controls(control_caption) object.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nigel RS" wrote in message
...
I have developed an application with custom toolbars. At the end of my
toolbar Excel adds a drop down 'Tool Bar Option' that lets the user
customize
the toolbars. Whilst I have set my custom bar option to no customise, the
user can still create a new toolbar and add their own controls!

Is it possible to disable this drop down or is there some other way to
prevent the user from accessing the customize toolbar options?

Many thanks