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("Customi ze...").Enabled=False
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Norman Jones" wrote in message
...
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?
---
Regards,
Norman
"areddy" wrote in
message ...
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 |
+-------------------------------------------------------------------+
--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread:
http://www.excelforum.com/showthread...hreadid=478143