Hi, Guys.
Is theer a way to create custtom excel ribbons without using the Office Custom UI tool? E.g. Somehow run code on the relevant xml that contains the ribbon definition?
Thanks.
Hi, Guys.
Is theer a way to create custtom excel ribbons without using the Office Custom UI tool? E.g. Somehow run code on the relevant xml that contains the ribbon definition?
Thanks.
You can certainly write vba code to manipulate the xml and res files. But you can not do it on an open workbook.
Access stores the ribbon xml in a table and there is much simpler to write custom xml on the fly. Unfortunately excel does not allow the same.
More information about the xml here.
https://msdn.microsoft.com/en-us/library/aa338202.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks