Disable Customize option in toolbar

[areddy]

Hello all,

i want to disable customize option in toolbars, means right click on tool bar and select customize option.now i want to disable that custmize option.

check the screen shot attachment.

thanks&Regards,
Amar...

[Norman Jones]

Hi Areddy,

Try:

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

---
Regards,
Norman



"areddy" <[email protected]> wrote in
message news:[email protected]...
>
> Hello all,
>
> i want to disable customize option in toolbars, means right click on
> tool bar and select customize option.now i want to disable that
> custmize option.
>
> check the screen shot attachment.
>
> thanks&Regards,
> Amar...
>
>
> +-------------------------------------------------------------------+
> |Filename: Customize disable.doc |
> |Download: http://www.excelforum.com/attachment.php?postid=3921 |
> +-------------------------------------------------------------------+
>
> --
> areddy
> ------------------------------------------------------------------------
> areddy's Profile:
> http://www.excelforum.com/member.php...o&userid=28204
> View this thread: http://www.excelforum.com/showthread...hreadid=477802
>

[areddy]

Hi Norman,

it is not working.

Regards,
Amar...

[Tom Ogilvy]

It works for me. This command was added around SR2 of Excel 97. If you
have an earlier version of xl97 it wasn't available, but then you would get
an error.

You do realize you have to run the code with that command in it?

--
Regards,
Tom Ogilvy

"areddy" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Norman,
>
> it is not working.
>
> Regards,
> Amar...
>
>
> --
> areddy
> ------------------------------------------------------------------------
> areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
> View this thread: http://www.excelforum.com/showthread...hreadid=477802
>

[Philip]

Hi,

I think he also wants to prevent users double-clicking on the toolbar area
which opens the Customize Toolbars dialog.

In XP/ Office 2004 this can be done using the command

application.disablecustomize = true

regards

Philip

"Tom Ogilvy" wrote:

> It works for me. This command was added around SR2 of Excel 97. If you
> have an earlier version of xl97 it wasn't available, but then you would get
> an error.
>
> You do realize you have to run the code with that command in it?
>
> --
> Regards,
> Tom Ogilvy
>
> "areddy" <[email protected]> wrote in
> message news:[email protected]...
> >
> > Hi Norman,
> >
> > it is not working.
> >
> > Regards,
> > Amar...
> >
> >
> > --
> > areddy
> > ------------------------------------------------------------------------
> > areddy's Profile:
> http://www.excelforum.com/member.php...o&userid=28204
> > View this thread: http://www.excelforum.com/showthread...hreadid=477802
> >
>
>
>

[Philip]

sorry, that should be:

Application.disablecustomize=true

"areddy" wrote:

>
> Hello all,
>
> i want to disable customize option in toolbars, means right click on
> tool bar and select customize option.now i want to disable that
> custmize option.
>
> check the screen shot attachment.
>
> thanks&Regards,
> Amar...
>
>
> +-------------------------------------------------------------------+
> |Filename: Customize disable.doc |
> |Download: http://www.excelforum.com/attachment.php?postid=3921 |
> +-------------------------------------------------------------------+
>
> --
> areddy
> ------------------------------------------------------------------------
> areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204
> View this thread: http://www.excelforum.com/showthread...hreadid=477802
>
>