Disable toolbar drop down

[Guest]

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



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.

 

[Guest]

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

 

[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 :