Hi,

I'm using Excel 2003.

I've created a custom toolbar for use in a certain document. This is the
only toolbar I would like the user to have access to. Therefore I've disabled
al other toolbars and disbled the "toolbar list". The only thing I can't
disable is the little toolbar option button (with a little down arrow in it)
on the right side of the custom toolbar.

Is there a way to disable this little button?

Cheers,

Paul.

Read this note from this page
http://www.rondebruin.nl/menuid.htm

Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.

On Error Resume Next
Application.CommandBars("Toolbar List").Enabled = False
On Error GoTo 0

This prevents users double-clicking on the Toolbar area to open the
(Customize Toolbars) dialog in Excel 2002 and above.
Application.CommandBars.DisableCustomize = True

If you want to remove “Type a question for Help” on the Worksheet Menu Bar you
can use this in Excel 2002 and above. True = hidden and False = visible
Application.CommandBars.DisableAskAQuestionDropdown = True

You can use this to avoid the error in Excel 2000

If Val(Application.Version) > 9 Then
CallByName CommandBars, "DisableCustomize", VbLet, True
CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
End If



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Paul" <(E-Mail Removed)> wrote in message news:381089D2-6FD1-40FA-B2EC-(E-Mail Removed)...
> Hi,
>
> I'm using Excel 2003.
>
> I've created a custom toolbar for use in a certain document. This is the
> only toolbar I would like the user to have access to. Therefore I've disabled
> al other toolbars and disbled the "toolbar list". The only thing I can't
> disable is the little toolbar option button (with a little down arrow in it)
> on the right side of the custom toolbar.
>
> Is there a way to disable this little button?
>
> Cheers,
>
> Paul.

Ron,

Thanks for the useful information, good info!

But;

I couldn't get quite what I was looking for;

I couldn't find any reference to the "Toolbar Options" button, It displays
on every toolbar (custom or regular) in excel 2003. (Other versions might as
well, I don't know). It's not a button with a faceID, it's a very narrow
button on the far right of every toolbar. When you click on it it will show a
drop down (sub)menu with " add or remove buttons" when you hoover this
(sub)menu the list with available toolbars will unfold (grayed out because I
disabled that), follow at the bottom with a option to "Customize". This
button i would like to disable / delete / whatever.... as long as the user
can't use it.

Any ideas?

Cheers,

Paul

"Ron de Bruin" wrote:

> Read this note from this page
> http://www.rondebruin.nl/menuid.htm
>
> Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.
>
> On Error Resume Next
> Application.CommandBars("Toolbar List").Enabled = False
> On Error GoTo 0
>
> This prevents users double-clicking on the Toolbar area to open the
> (Customize Toolbars) dialog in Excel 2002 and above.
> Application.CommandBars.DisableCustomize = True
>
> If you want to remove “Type a question for Help” on the Worksheet Menu Bar you
> can use this in Excel 2002 and above. True = hidden and False = visible
> Application.CommandBars.DisableAskAQuestionDropdown = True
>
> You can use this to avoid the error in Excel 2000
>
> If Val(Application.Version) > 9 Then
> CallByName CommandBars, "DisableCustomize", VbLet, True
> CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
> End If
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
>
>
> "Paul" <(E-Mail Removed)> wrote in message news:381089D2-6FD1-40FA-B2EC-(E-Mail Removed)...
> > Hi,
> >
> > I'm using Excel 2003.
> >
> > I've created a custom toolbar for use in a certain document. This is the
> > only toolbar I would like the user to have access to. Therefore I've disabled
> > al other toolbars and disbled the "toolbar list". The only thing I can't
> > disable is the little toolbar option button (with a little down arrow in it)
> > on the right side of the custom toolbar.
> >
> > Is there a way to disable this little button?
> >
> > Cheers,
> >
> > Paul.
>
>

Hi Paul

Application.CommandBars.DisableCustomize = True

The arrow is still there but the options in the menu are disabled

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Paul" <(E-Mail Removed)> wrote in message news:BB0FE84F-2171-4DB3-8EB9-(E-Mail Removed)...
> Ron,
>
> Thanks for the useful information, good info!
>
> But;
>
> I couldn't get quite what I was looking for;
>
> I couldn't find any reference to the "Toolbar Options" button, It displays
> on every toolbar (custom or regular) in excel 2003. (Other versions might as
> well, I don't know). It's not a button with a faceID, it's a very narrow
> button on the far right of every toolbar. When you click on it it will show a
> drop down (sub)menu with " add or remove buttons" when you hoover this
> (sub)menu the list with available toolbars will unfold (grayed out because I
> disabled that), follow at the bottom with a option to "Customize". This
> button i would like to disable / delete / whatever.... as long as the user
> can't use it.
>
> Any ideas?
>
> Cheers,
>
> Paul
>
> "Ron de Bruin" wrote:
>
>> Read this note from this page
>> http://www.rondebruin.nl/menuid.htm
>>
>> Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.
>>
>> On Error Resume Next
>> Application.CommandBars("Toolbar List").Enabled = False
>> On Error GoTo 0
>>
>> This prevents users double-clicking on the Toolbar area to open the
>> (Customize Toolbars) dialog in Excel 2002 and above.
>> Application.CommandBars.DisableCustomize = True
>>
>> If you want to remove “Type a question for Help” on the Worksheet Menu Bar you
>> can use this in Excel 2002 and above. True = hidden and False = visible
>> Application.CommandBars.DisableAskAQuestionDropdown = True
>>
>> You can use this to avoid the error in Excel 2000
>>
>> If Val(Application.Version) > 9 Then
>> CallByName CommandBars, "DisableCustomize", VbLet, True
>> CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
>> End If
>>
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>>
>>
>> "Paul" <(E-Mail Removed)> wrote in message news:381089D2-6FD1-40FA-B2EC-(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm using Excel 2003.
>> >
>> > I've created a custom toolbar for use in a certain document. This is the
>> > only toolbar I would like the user to have access to. Therefore I've disabled
>> > al other toolbars and disbled the "toolbar list". The only thing I can't
>> > disable is the little toolbar option button (with a little down arrow in it)
>> > on the right side of the custom toolbar.
>> >
>> > Is there a way to disable this little button?
>> >
>> > Cheers,
>> >
>> > Paul.
>>
>>

Ron,

Thanks, I'll try it as soon as I get back from my vacation!!

Cheers,

Paul

"Ron de Bruin" wrote:

> Hi Paul
>
> Application.CommandBars.DisableCustomize = True
>
> The arrow is still there but the options in the menu are disabled
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
>
>
> "Paul" <(E-Mail Removed)> wrote in message news:BB0FE84F-2171-4DB3-8EB9-(E-Mail Removed)...
> > Ron,
> >
> > Thanks for the useful information, good info!
> >
> > But;
> >
> > I couldn't get quite what I was looking for;
> >
> > I couldn't find any reference to the "Toolbar Options" button, It displays
> > on every toolbar (custom or regular) in excel 2003. (Other versions might as
> > well, I don't know). It's not a button with a faceID, it's a very narrow
> > button on the far right of every toolbar. When you click on it it will show a
> > drop down (sub)menu with " add or remove buttons" when you hoover this
> > (sub)menu the list with available toolbars will unfold (grayed out because I
> > disabled that), follow at the bottom with a option to "Customize". This
> > button i would like to disable / delete / whatever.... as long as the user
> > can't use it.
> >
> > Any ideas?
> >
> > Cheers,
> >
> > Paul
> >
> > "Ron de Bruin" wrote:
> >
> >> Read this note from this page
> >> http://www.rondebruin.nl/menuid.htm
> >>
> >> Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above.
> >>
> >> On Error Resume Next
> >> Application.CommandBars("Toolbar List").Enabled = False
> >> On Error GoTo 0
> >>
> >> This prevents users double-clicking on the Toolbar area to open the
> >> (Customize Toolbars) dialog in Excel 2002 and above.
> >> Application.CommandBars.DisableCustomize = True
> >>
> >> If you want to remove “Type a question for Help” on the Worksheet Menu Bar you
> >> can use this in Excel 2002 and above. True = hidden and False = visible
> >> Application.CommandBars.DisableAskAQuestionDropdown = True
> >>
> >> You can use this to avoid the error in Excel 2000
> >>
> >> If Val(Application.Version) > 9 Then
> >> CallByName CommandBars, "DisableCustomize", VbLet, True
> >> CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True
> >> End If
> >>
> >>
> >>
> >> --
> >>
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl/tips.htm
> >>
> >>
> >>
> >>
> >> "Paul" <(E-Mail Removed)> wrote in message news:381089D2-6FD1-40FA-B2EC-(E-Mail Removed)...
> >> > Hi,
> >> >
> >> > I'm using Excel 2003.
> >> >
> >> > I've created a custom toolbar for use in a certain document. This is the
> >> > only toolbar I would like the user to have access to. Therefore I've disabled
> >> > al other toolbars and disbled the "toolbar list". The only thing I can't
> >> > disable is the little toolbar option button (with a little down arrow in it)
> >> > on the right side of the custom toolbar.
> >> >
> >> > Is there a way to disable this little button?
> >> >
> >> > Cheers,
> >> >
> >> > Paul.
> >>
> >>
>
>