Thread: Help Combo Box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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