Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi Marcello,
Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi Marcello,
To disable and hide the menubar Help menu, try: '============= Public Sub Tester() With Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help") .Enabled = False .Visible = False End With End Sub '<<============= Note that Help may still be accessed via the F1 key. If you also wish to disable this access, add the instruction: Application.OnKey "{F1}", "" To restore these settings, try: '============= Public Sub RestoreHelp() With Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help") .Enabled = True .Visible = True End With Application.OnKey "{F1}" End Sub '<<============= --- Regards, Norman "Norman Jones" wrote in message ... Hi Marcello, Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Ron, this link is broken: http://www.rondebruin.com/menuid.htm
"Ron de Bruin" wrote in message ... I like to add this to Norman's answer Note: this code blow in a non English version Use the ID of the Help menu For Example a French version use a ? Application.CommandBars("Worksheet Menu Bar") _ .FindControl(ID:=30010).Enabled = False See also http://www.rondebruin.com/menuid.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Marcello, Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi Mike
Is working for me Try again -- Regards Ron De Bruin http://www.rondebruin.nl "Mike Fogleman" wrote in message ... Ron, this link is broken: http://www.rondebruin.com/menuid.htm "Ron de Bruin" wrote in message ... I like to add this to Norman's answer Note: this code blow in a non English version Use the ID of the Help menu For Example a French version use a ? Application.CommandBars("Worksheet Menu Bar") _ .FindControl(ID:=30010).Enabled = False See also http://www.rondebruin.com/menuid.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Marcello, Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
I like to add this to Norman's answer
Note: this code blow in a non English version Use the ID of the Help menu For Example a French version use a ? Application.CommandBars("Worksheet Menu Bar") _ ..FindControl(ID:=30010).Enabled = False See also http://www.rondebruin.com/menuid.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Marcello, Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Now we have a problem
I have no control of my com site anymore There are only two pages on the site but this is not OK -- Regards Ron De Bruin http://www.rondebruin.nl "Mike Fogleman" wrote in message ... Ron, this link is broken: http://www.rondebruin.com/menuid.htm "Ron de Bruin" wrote in message ... I like to add this to Norman's answer Note: this code blow in a non English version Use the ID of the Help menu For Example a French version use a ? Application.CommandBars("Worksheet Menu Bar") _ .FindControl(ID:=30010).Enabled = False See also http://www.rondebruin.com/menuid.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Marcello, Try: '============= Public Sub Tester() Application.CommandBars("Worksheet Menu Bar"). _ Controls("Help").Enabled = False End Sub '<<============= --- Regards, Norman "Marcelo Rychter" <Marcelo.Rychter.28un7a_1149376801.0119@excelfor um-nospam.com wrote in message news:Marcelo.Rychter.28un7a_1149376801.0119@excelf orum-nospam.com... Hi folks, I'm trying to take off the 'Help Combo Box' from the menu bar line, using VBA but I didn't succeed. Can you guys tell me how to do that? Thanks in advance, Marcelo Rychter -- Marcelo Rychter ------------------------------------------------------------------------ Marcelo Rychter's Profile: http://www.excelforum.com/member.php...o&userid=35066 View this thread: http://www.excelforum.com/showthread...hreadid=548176 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi Ron,
Now we have a problem I have no control of my com site anymore There are only two pages on the site but this is not OK I have no problem accessing your site --- Regards, Norman |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Combo Box
Hi Norman
..nl is working but not .com There are only two pages on the com site that not working now http://www.rondebruin.com/menuid.htm and http://www.rondebruin.com/atptranslator.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Ron, Now we have a problem I have no control of my com site anymore There are only two pages on the site but this is not OK I have no problem accessing your site --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |