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?
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?
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?
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
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Surely, if you are disabling the Worksheet Menu commandbar, Help goes with it.Originally Posted by d4vem
Not sure if the OP means the Help menu or the Help search bar..
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
I mean't the Help searchbar
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....
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
LOL! You'll like just how easy this is.
[vba]Application.CommandBars.DisableAskAQuestionDropdown = True[/vba]
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Originally Posted by Ken Puls
ugh....how did I miss that!!! LOL!
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
See this site : http://www.newbytes.be/
and look :
Instellingen herstellen (REPAIR Commandbars)
Wen jou open the file click the first button.
- Geknoeid in Excel? Uw werkbalken verdwenen? De snelmenu van uw rechtermuisknop heeft te veel menuonderdelen gekregen? Dit is de oplossing!
If you see in VBA :
Sub WerkbalkenTerug()
Application.CommandBars(1).Enabled = True
End Sub
P.
sorry, can't delete post?
It was the rong answert
P.
No problem, you posted a correction. No worries.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
That worked fine.
Thanks very much Ken
Sorry it works fine in Windows 2003 but fails in Windows 2000. Is there any reason that can happen?
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).
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Therefore is there my way of identifing what Office environment you are operating on? Or is that a seperate post?
Any Office application | Help | About Microsoft xxxxxx
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
I use 2000 at work, and it's not there for me.....Originally Posted by firefytr
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
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
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
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables