Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the toolbar options button
Hi,
I'm using Excel 2003. I've created a custom toolbar for use in a certain document. This is the only toolbar I would like the user to have access to. Therefore I've disabled al other toolbars and disbled the "toolbar list". The only thing I can't disable is the little toolbar option button (with a little down arrow in it) on the right side of the custom toolbar. Is there a way to disable this little button? Cheers, Paul. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the toolbar options button
Read this note from this page
http://www.rondebruin.nl/menuid.htm Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above. On Error Resume Next Application.CommandBars("Toolbar List").Enabled = False On Error GoTo 0 This prevents users double-clicking on the Toolbar area to open the (Customize Toolbars) dialog in Excel 2002 and above. Application.CommandBars.DisableCustomize = True If you want to remove Type a question for Help on the Worksheet Menu Bar you can use this in Excel 2002 and above. True = hidden and False = visible Application.CommandBars.DisableAskAQuestionDropdow n = True You can use this to avoid the error in Excel 2000 If Val(Application.Version) 9 Then CallByName CommandBars, "DisableCustomize", VbLet, True CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Hi, I'm using Excel 2003. I've created a custom toolbar for use in a certain document. This is the only toolbar I would like the user to have access to. Therefore I've disabled al other toolbars and disbled the "toolbar list". The only thing I can't disable is the little toolbar option button (with a little down arrow in it) on the right side of the custom toolbar. Is there a way to disable this little button? Cheers, Paul. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the toolbar options button
Ron,
Thanks for the useful information, good info! But; I couldn't get quite what I was looking for; I couldn't find any reference to the "Toolbar Options" button, It displays on every toolbar (custom or regular) in excel 2003. (Other versions might as well, I don't know). It's not a button with a faceID, it's a very narrow button on the far right of every toolbar. When you click on it it will show a drop down (sub)menu with " add or remove buttons" when you hoover this (sub)menu the list with available toolbars will unfold (grayed out because I disabled that), follow at the bottom with a option to "Customize". This button i would like to disable / delete / whatever.... as long as the user can't use it. Any ideas? Cheers, Paul "Ron de Bruin" wrote: Read this note from this page http://www.rondebruin.nl/menuid.htm Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above. On Error Resume Next Application.CommandBars("Toolbar List").Enabled = False On Error GoTo 0 This prevents users double-clicking on the Toolbar area to open the (Customize Toolbars) dialog in Excel 2002 and above. Application.CommandBars.DisableCustomize = True If you want to remove Type a question for Help on the Worksheet Menu Bar you can use this in Excel 2002 and above. True = hidden and False = visible Application.CommandBars.DisableAskAQuestionDropdow n = True You can use this to avoid the error in Excel 2000 If Val(Application.Version) 9 Then CallByName CommandBars, "DisableCustomize", VbLet, True CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Hi, I'm using Excel 2003. I've created a custom toolbar for use in a certain document. This is the only toolbar I would like the user to have access to. Therefore I've disabled al other toolbars and disbled the "toolbar list". The only thing I can't disable is the little toolbar option button (with a little down arrow in it) on the right side of the custom toolbar. Is there a way to disable this little button? Cheers, Paul. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the toolbar options button
Hi Paul
Application.CommandBars.DisableCustomize = True The arrow is still there but the options in the menu are disabled -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Ron, Thanks for the useful information, good info! But; I couldn't get quite what I was looking for; I couldn't find any reference to the "Toolbar Options" button, It displays on every toolbar (custom or regular) in excel 2003. (Other versions might as well, I don't know). It's not a button with a faceID, it's a very narrow button on the far right of every toolbar. When you click on it it will show a drop down (sub)menu with " add or remove buttons" when you hoover this (sub)menu the list with available toolbars will unfold (grayed out because I disabled that), follow at the bottom with a option to "Customize". This button i would like to disable / delete / whatever.... as long as the user can't use it. Any ideas? Cheers, Paul "Ron de Bruin" wrote: Read this note from this page http://www.rondebruin.nl/menuid.htm Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above. On Error Resume Next Application.CommandBars("Toolbar List").Enabled = False On Error GoTo 0 This prevents users double-clicking on the Toolbar area to open the (Customize Toolbars) dialog in Excel 2002 and above. Application.CommandBars.DisableCustomize = True If you want to remove Type a question for Help on the Worksheet Menu Bar you can use this in Excel 2002 and above. True = hidden and False = visible Application.CommandBars.DisableAskAQuestionDropdow n = True You can use this to avoid the error in Excel 2000 If Val(Application.Version) 9 Then CallByName CommandBars, "DisableCustomize", VbLet, True CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Hi, I'm using Excel 2003. I've created a custom toolbar for use in a certain document. This is the only toolbar I would like the user to have access to. Therefore I've disabled al other toolbars and disbled the "toolbar list". The only thing I can't disable is the little toolbar option button (with a little down arrow in it) on the right side of the custom toolbar. Is there a way to disable this little button? Cheers, Paul. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable the toolbar options button
Ron,
Thanks, I'll try it as soon as I get back from my vacation!! Cheers, Paul "Ron de Bruin" wrote: Hi Paul Application.CommandBars.DisableCustomize = True The arrow is still there but the options in the menu are disabled -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Ron, Thanks for the useful information, good info! But; I couldn't get quite what I was looking for; I couldn't find any reference to the "Toolbar Options" button, It displays on every toolbar (custom or regular) in excel 2003. (Other versions might as well, I don't know). It's not a button with a faceID, it's a very narrow button on the far right of every toolbar. When you click on it it will show a drop down (sub)menu with " add or remove buttons" when you hoover this (sub)menu the list with available toolbars will unfold (grayed out because I disabled that), follow at the bottom with a option to "Customize". This button i would like to disable / delete / whatever.... as long as the user can't use it. Any ideas? Cheers, Paul "Ron de Bruin" wrote: Read this note from this page http://www.rondebruin.nl/menuid.htm Disable right clicking on the worksheet menu bar and other bars in 97 SR1 and above. On Error Resume Next Application.CommandBars("Toolbar List").Enabled = False On Error GoTo 0 This prevents users double-clicking on the Toolbar area to open the (Customize Toolbars) dialog in Excel 2002 and above. Application.CommandBars.DisableCustomize = True If you want to remove Type a question for Help on the Worksheet Menu Bar you can use this in Excel 2002 and above. True = hidden and False = visible Application.CommandBars.DisableAskAQuestionDropdow n = True You can use this to avoid the error in Excel 2000 If Val(Application.Version) 9 Then CallByName CommandBars, "DisableCustomize", VbLet, True CallByName CommandBars, "DisableAskAQuestionDropdown", VbLet, True End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul" wrote in message ... Hi, I'm using Excel 2003. I've created a custom toolbar for use in a certain document. This is the only toolbar I would like the user to have access to. Therefore I've disabled al other toolbars and disbled the "toolbar list". The only thing I can't disable is the little toolbar option button (with a little down arrow in it) on the right side of the custom toolbar. Is there a way to disable this little button? Cheers, Paul. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
disable tab worksheet options | Excel Programming | |||
how to enable / disable customised button on toolbar | Excel Programming | |||
Disable commad bar options | Excel Programming | |||
Disable options | Excel Programming |