Solved: Remove Help Menu

[d4vem]

Hope anyone can help.

I have a file that when opened makes the excel default menus invisible and creates custom menus. This is fine however the help menu dropdown is still available in the menubar. Is there anyway to also remove this?

[Cyberdude]

Be careful what you ask for ... you might get it. Are you sure you want to remove Help??

Try this:
Right click on an empty spot in the toolbar.
Select "Customize" from the list.
Right click on the Help icon.
Click on the "Delete" option.
Click "Close" on the dialog box to get out of Customize.

Is it gone?

[malik641]

Don't delete it. I would be too afraid to lose it for good if I did that.

Try this:
[vba]
Commandbars(1).Controls("Help").Visible = False[/vba]
And if you want it to toggle:
[vba]
Commandbars(1).Controls("Help").Visible = Not commandbars(1).Controls("Help").Visible[/vba]
HTH

[Bob Phillips]

Hope anyone can help.

I have a file that when opened makes the excel default menus invisible and creates custom menus. This is fine however the help menu dropdown is still available in the menubar. Is there anyway to also remove this?

Surely, if you are disabling the Worksheet Menu commandbar, Help goes with it.

[Zack Barresse]

Not sure if the OP means the Help menu or the Help search bar..

[d4vem]

I mean't the Help searchbar

[malik641]

Do you mean the "Type a question" box?

If so, I found some info here:
http://www.annoyances.org/exec/show/article08-101

But I'm not sure how to get to it by VBA...yet....

[Ken Puls]

LOL! You'll like just how easy this is.

[vba]Application.CommandBars.DisableAskAQuestionDropdown = True[/vba]

[malik641]

LOL! You'll like just how easy this is.

[vba]Application.CommandBars.DisableAskAQuestionDropdown = True[/vba]

ugh....how did I miss that!!! LOL!

[Pinokkio]

See this site : http://www.newbytes.be/

and look :
Instellingen herstellen (REPAIR Commandbars)

• Geknoeid in Excel? Uw werkbalken verdwenen? De snelmenu van uw rechtermuisknop heeft te veel menuonderdelen gekregen? Dit is de oplossing!

Wen jou open the file click the first button.

If you see in VBA :

Sub WerkbalkenTerug()
Application.CommandBars(1).Enabled = True
End Sub


P.

[Pinokkio]

sorry, can't delete post?
It was the rong answert

P.

[Zack Barresse]

No problem, you posted a correction. No worries.

[d4vem]

That worked fine.

Thanks very much Ken

[d4vem]

Sorry it works fine in Windows 2003 but fails in Windows 2000. Is there any reason that can happen?

[Zack Barresse]

Windows won't have anything to do with it, but Office will. I don't think the help drop down was in Excel 2000, but I could be wrong (don't have it here to test).

[d4vem]

Therefore is there my way of identifing what Office environment you are operating on? Or is that a seperate post?

[Zack Barresse]

Any Office application | Help | About Microsoft xxxxxx

[malik641]

Windows won't have anything to do with it, but Office will. I don't think the help drop down was in Excel 2000, but I could be wrong (don't have it here to test).

I use 2000 at work, and it's not there for me.....

[d4vem]

If you read the initial post it was to hide the help drop down menu in the menu bar. The problem is this

Thanks from Ken and it works fine in Office 2003 (which is my verson)

However on implementing to the client they are on Office version 2000 and it fails. Therefore is there anyway to do either of the following?

1. Understand what Office version is currently installed
2. Have a comand that is compatible accross Office 2000 & 2003

Thanks in advance

[Zack Barresse]

To test the version...

[vba]If Int(Application.Version) > 9 Then
Msgbox "You are using Excel 2002 (XP) or greater.", vbinformation
Else
Msgbox "You are using Excel 2000 or below.", vbinformation
End if[/vba]

HTH