Adding CustomUI Ribbon code using macro to new generated file

V

vikasmadaan25

Hello

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

Vikas Madaan
 
V

vikasmadaan25

vikasmadaan25 wrote on 08/06/2011 17:34 ET
Hello

I am generating excel macro files using macros and I want to add customU cod
to them is it possible to add it using vba

Vikas Madaa
Strange no one replied

Any how i made the code to add the CustomUI to the xlsm file using macro bu
strangrly its not picking the customUI code in the file

Vikas
 
J

Jim Rech

If you have the ribbonX in your file in the proper place and you do not see
the expected changes to the ribbon there may be an error in the ribbonX.
Make sure you have "Show add-in user interface errors" selected in Excel
Advanced Options, General section so Excel will alert you to any errors.
 
G

GS

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.
 
V

vikasmadaan25

GS wrote on 08/08/2011 10:42 ET
vikasmadaan25 submitted this idea
AFAIK, custom UI changes need to be done by editing the XML of the fil
you want the changes to be implemented by. See my reply to your othe
post for Ron de Bruin's solutions for customizing the UI and Ribbon

Garr

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

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

Vikas Madaan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top