Custom Toolbars

N

Nigel RS

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
 
B

Bob Phillips

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)
 
N

Nigel RS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top