sombradeti
New Member
- Joined
- Dec 15, 2010
- Messages
- 38
I made some custom buttons for the excel ribbon using XML on a CustomUI.xml file, however, when I save the excel file as another format and then try to save my file back to the .xlsm format all my buttons disappear. What I want to know is, can I store my XML data as a string in VBA and have a macro install the buttons from that? If that is possible how would I go about doing it?<?XML:NAMESPACE PREFIX = [default] <a href= NS = "<a href=" /><customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:><customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:>
<ribbon>
<tabs></customUI>
<customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:><tab idMso="TabHome">
<group id=customGroup1 insertAfterMso="GroupEditingExcel" label="Logging"></customUI>
<customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:></customUI></group></tab></tabs></ribbon></customUI>
<ribbon>
<tabs></customUI>
<customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:><tab idMso="TabHome">
<group id=customGroup1 insertAfterMso="GroupEditingExcel" label="Logging"></customUI>
<customUI xmlns="<a href=" target="_blank" customui? 01 2006 office schemas.microsoft.com http:></customUI></group></tab></tabs></ribbon></customUI>
Last edited: