Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
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 +------------------------------------------------------------------- -- aredd ----------------------------------------------------------------------- areddy's Profile: http://www.excelforum.com/member.php...fo&userid=2820 View this thread: http://www.excelforum.com/showthread.php?threadid=47780 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
Hi Areddy,
Try: Application.CommandBars("Toolbar List").Enabled = False --- Regards, Norman "areddy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Customize option in toolbar
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
Disable Customize in Excel 10,11 | Excel Programming | |||
Disable Customize in Excel 10,11 | Excel Programming | |||
Disable Customize in Excel 10,11 | Excel Programming |