GS wrote on 08/08/2011 10:42 ET :
vikasmadaan25 submitted this idea :
Hello,

I am generating excel macro files using macros and I want to add customUI
code to them is it possible to add it using vba?

Vikas Madaan



AFAIK, custom UI changes need to be done by editing the XML of the file
you want the changes to be implemented by. See my reply to your other
post for Ron de Bruin's solutions for customizing the UI and Ribbon.

Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi,

I hv found the issue why it was not working, I was adding the customui.xls
file
in customUI Folder but was not changing the .rels file in the _rels folder, it
working now, finally i found the solution to dynamically add xml code in the
new
generated file thru macro.

Vikas Madaan