Custom Toolbars
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
|