PDA

View Full Version : Solved: Remove Help Menu



d4vem
08-20-2006, 07:11 AM
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
08-20-2006, 09:02 AM
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
08-20-2006, 03:36 PM
Don't delete it. I would be too afraid to lose it for good if I did that.

Try this:

Commandbars(1).Controls("Help").Visible = False
And if you want it to toggle:

Commandbars(1).Controls("Help").Visible = Not commandbars(1).Controls("Help").Visible
HTH :thumb

Bob Phillips
08-20-2006, 04:07 PM
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
08-21-2006, 08:56 AM
Not sure if the OP means the Help menu or the Help search bar..

d4vem
08-22-2006, 01:53 PM
I mean't the Help searchbar

malik641
08-22-2006, 06:55 PM
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
08-22-2006, 09:02 PM
LOL! You'll like just how easy this is. ;)

Application.CommandBars.DisableAskAQuestionDropdown = True

:)

malik641
08-22-2006, 09:08 PM
LOL! You'll like just how easy this is. ;)

Application.CommandBars.DisableAskAQuestionDropdown = True
:)
:rotlaugh:

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

Pinokkio
08-23-2006, 08:38 AM
See this site : http://www.newbytes.be/

and look :
Instellingen herstellen (http://users.skynet.be/onderland/Downloads/GroteNood.zip) (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
08-23-2006, 08:52 AM
sorry, can't delete post?
It was the rong answert

P.

Zack Barresse
08-23-2006, 09:58 AM
No problem, you posted a correction. No worries. :)

d4vem
08-23-2006, 11:45 AM
That worked fine.

Thanks very much Ken

d4vem
08-24-2006, 07:24 AM
Sorry it works fine in Windows 2003 but fails in Windows 2000. Is there any reason that can happen?

Zack Barresse
08-24-2006, 08:08 AM
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
08-24-2006, 11:27 AM
Therefore is there my way of identifing what Office environment you are operating on? Or is that a seperate post?

Zack Barresse
08-24-2006, 11:41 AM
Any Office application | Help | About Microsoft xxxxxx

malik641
08-24-2006, 02:36 PM
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
08-25-2006, 12:35 PM
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
08-25-2006, 12:42 PM
To test the version...

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

HTH

lucas
08-25-2006, 12:44 PM
or check for the existance of the help drop down

lucas
08-25-2006, 12:47 PM
Tell me if I'm out of school here but with Zacks code....


If Int(Application.Version) > 9 Then
run code to remove help drop down
Else
go to next procedure
End If

Zack Barresse
08-25-2006, 01:00 PM
Yeah, pretty much. Unless I miscalculated the version number..?? Let's see...

2003 = 11.0
2002 = 10.0
2000 = 9.0
97 = 8.0
...

Yup, that seems to be good. :yes