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
|