Disable Customize option in toolbar

A

areddy

Hello all,

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

check the screen shot attachment.

thanks&Regards,
Amar..

+-------------------------------------------------------------------
|Filename: Customize disable.doc
|Download: http://www.excelforum.com/attachment.php?postid=3921
+-------------------------------------------------------------------
 
T

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?
 
P

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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top