Removing all toolbar in Office 2007 using VBA
Hello Excelers,
I want to remove all toolbars (listed below) and want to show my own customized toolbar to the customers. How should we do it in excel if I want to remove all toolbar like:
1. Home
2. Insert
3. Page Layout
4. Formulas
5. Data
6. Review
7. View
8. Developer
and insert my own customize toolbar in AddIns. Thank You
I'm afraid not something many of us know much about however you might want to check out some or all of the following:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
also:
http://www.rondebruin.nl/ribbon.htm
(author as per MS articles)
and:
http://www.andypope.info/vba/ribboneditor.htm
...hopefully some / all of the above will prove useful to you in the meantime
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks D.Ote for replying this thread. I have made a customized icon or toolbar you can say and I was trying to hide my toolbars but it is not working. See the attachment for review. Appreciate it
Isn't this post sort of repeated here?
I posted some links in there that might help you deal with 2007 ribbons.
This is a boderline duplicate thread, and I'm closing it. Continue in your other thread, please, so everybody stays on the same page.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks