Removing all toolbar in Office 2007 using VBA

[klm9971]

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

[DonkeyOte]

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

[klm9971]

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

[quekbc]

Isn't this post sort of repeated here?

I posted some links in there that might help you deal with 2007 ribbons.

[teylyn]

This is a boderline duplicate thread, and I'm closing it. Continue in your other thread, please, so everybody stays on the same page.