Disable Customize toolber tabs

[areddy]

Dear All,

I want to disable Customize toolbar tabs.see the scren shot in
attachment.
what is the code to disable the Tabs.

please help me...

Regards,
Amar...


+-------------------------------------------------------------------+
|Filename: Disable Customize toolber tabs.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3933 |
+-------------------------------------------------------------------+

 

[Norman Jones]

Hi Areddy,

You posed the identical question yesterday.

I responded with the suggestion:

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

You responded, monosyllabically, that this did not work.

Tom Ogilvy pointed out that the suggestion should work in any version of
Excel from xl97 SP2 onwards and queried the version you use.

Why not stay in the original thread and provide some feedback designed to
enable prospective respondents better to assist you?

 

[Leith Ross]

Hello areddy,

If you disable the tabs, you won't be able to use the Customize Toolbar
features. Since this is an Excel built-in dialog, you aren't able to
disable the tabs anyway.

Sincerely,
Leith Ross

 

[Bob Phillips]

See response in programming.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

I think he means the tabs on the customize dialog. I don't think that can be
done, but you could disable the customize control, and stop the right-click
customize option with

Application.CommandBars("Toolbar List").Enabled = False
Application.CommandBars("Tools").Controls("Customize...").Enabled=False


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Norman Jones]

Hi Bob,

I think he means the tabs on the customize dialog

Thank you.

I responded in the Excel group, providing the OP with a link to all his
posts and drwaing his attention to your reply here!

 

[Philip]

Hi all,

The Customize toolbars dialog can ONLY be disabled in Office XP / 2003

You can use

Application.disablecustomize=true

This prevents users double-clicking on the Toolbar area to open the
(Customize Toolbars) dialog and bypass the

ToolbarList.enabled=false

In our Excel Apps we use this to prevent the users gaining access to
features that we don't want them to have... for example, if we disable all
the menus and toolbars, leaving them with only our custom commandbars, then
we don't want the users double-clicking on the Toolbar area to open that
dialog, then adding a new toolbar and then adding the buttons from the
Commands Tab

Of course, when the workbook is closed, it is important to reset all those
features...

I hope this helps ...

Philip

See response in programming.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Philip]

Sorry, that should be

Application.CommandBars.DisableCustomize=true

cheers

Philip