LinkBack URL
About LinkBacks
Hi all,
Can someone point me in the direction of getting rid of the Menu Ribbon in Excel2007-via code? It was very easily done in the earlier versions of Excel when there was no Ribbon.
Many thanks in advance.
Hi all,
Can someone point me in the direction of getting rid of the Menu Ribbon in Excel2007-via code? It was very easily done in the earlier versions of Excel when there was no Ribbon.
Many thanks in advance.
Hello davidm,
What about just:
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon,
Thanks a million! That worked like charm!
David
Hi David, perhaps try:
Change False to True to un-hide the ribbon.Please Login or Register to view this content.
Hi Paul, that's a first time view for mewhat is Excel14Macro?Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
It's "Excel4Macro", not 14.
Old stuff still built into Excel from many eons ago that I have no clue about, to be honest. I just know there are various uses for it and Google helps! Not sure if it's still in Excel 2010 since I don't have that version.
To view the Excel 4.0 Macro help file you can download the macrofun.exe file from Microsoft (http://www.microsoft.com/download/en...ang=en&id=1465). Install and create a folder for the contents, then run the HLP file.
Note: If you're using Windows Vista or newer (or Server 2008+) you'll need to download Windows' Help File viewer to view HLP files. That can be downloaded here: http://support.microsoft.com/kb/917607
@ Mordred,
Yes, Paul did surprise me as well, however:
It iswhat is Excel14Macro?what is Excel4Macro and not 14
You are welcome David,
If your problem is solved, please do see the notes below about marking your Thread as solved.
Be extremely careful doing this, you must always restore features back to the original
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
@ royUK,
Yes Roy, you are right. I assumed that davidm would do just that with the WorkBook Open and Before Close Events. Something like:
And;Please Login or Register to view this content.
Please Login or Register to view this content.
In my experience more people use something like this without thinking about restoring the features that they have turned off.
Last edited by royUK; 03-06-2012 at 03:42 AM.
@ royUK
I must admit that I do prefer your "AppReset" much more!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks