Disable toolbar drop down

[BobbyS]

I have an Excel application in which I am trying to disable some options for
protection. I have everything locked down with one exception. The user can
still right click in the toolbar area and get the list of available
toolbars/customize list. I need to disable this so the user cannot turn on a
toolbar and jeopardize the workbook. I haven't been able to find any
information as to how to do this. I have looked at API calls and haven't had
any luck.

Any help would be appreciatged.

[Jim Cone]

B,

Application.CommandBars("Toolbar List").Enabled = False

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"BobbyS" <BobbyS@discussions.microsoft.com> wrote in message...
I have an Excel application in which I am trying to disable some options for
protection. I have everything locked down with one exception. The user can
still right click in the toolbar area and get the list of available
toolbars/customize list. I need to disable this so the user cannot turn on a
toolbar and jeopardize the workbook. I haven't been able to find any
information as to how to do this. I have looked at API calls and haven't had
any luck.

Any help would be appreciatged.

[Vic Eldridge]

Hi Bobby,

Jim's shown you how to deal with the right click, but AFAIK, there's no real
way to prevent the Customize dialog from being shown when you double click in
the toolbar area. I hope someone else can prove me wrong.

Regards,
Vic Eldridge




"BobbyS" wrote:

> I have an Excel application in which I am trying to disable some options for
> protection. I have everything locked down with one exception. The user can
> still right click in the toolbar area and get the list of available
> toolbars/customize list. I need to disable this so the user cannot turn on a
> toolbar and jeopardize the workbook. I haven't been able to find any
> information as to how to do this. I have looked at API calls and haven't had
> any luck.
>
> Any help would be appreciatged.

[keepITcool]

in xl2002 and newer:
Commandbars.DisableCustomize=True

Note: the dropdown indicator still shows,
but no more customization for our dear friend: "the user"


to prevent runtime errors code like:

#If VBA6 Then
If Val(Application.Version) >= 10 Then
CallByName CommandBars, "DisableCustomize", VbLet, True
End If
#End If




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Vic Eldridge wrote :

> Hi Bobby,
>
> Jim's shown you how to deal with the right click, but AFAIK, there's
> no real way to prevent the Customize dialog from being shown when you
> double click in the toolbar area. I hope someone else can prove me
> wrong.
>
> Regards,
> Vic Eldridge
>
>
>
>
> "BobbyS" wrote:
>
> > I have an Excel application in which I am trying to disable some
> > options for protection. I have everything locked down with one
> > exception. The user can still right click in the toolbar area and
> > get the list of available toolbars/customize list. I need to
> > disable this so the user cannot turn on a toolbar and jeopardize
> > the workbook. I haven't been able to find any information as to how
> > to do this. I have looked at API calls and haven't had any luck.
> >
> > Any help would be appreciatged.