hi guys,
I am currently optimizing a project system which has about 300 controls, divided in 9 groups (every group has about 5-20 sub menus), currently stored in the 'Add-Ins' tab. Because of usability, I used the custom ui editor in the last days to put this hierarchy into a ribbon bar, which is placed before the Home Tab, and gets loaded when anyone opens the .xlsm file (I call it 'parent-file' in this post). everything works quite fine, the controls are dynamic and users are able to change the language in the menu, when they do, the labels invalidate and get their translated pendant.
now I am on the next stage of this project, as there are certain .doc or .ppt files, which get executed/requested/edited from time to time, and till now, have their 'Add-Ins' controls to do certain things. My question is now: Is it possible to create a ribbon which has like the same characteristics as the one I already created? it should open, as someone executes the .doc/.ppt/..., and close again, when the file is closed (through the vba-procedure, of course). as u could imagine, I am searching the web for something since 3 days. I guess I almost found any possible solution, also tried a lot, but every way got his own issues imo.
to sum this up: First of all: I already know the CUSTOM UI EDITOR! pls do not tell me that it is way easier to edit the ribbon through this neat little program, as it is not practical for the problem I am facing
opening the .xlsm file as a zip and editing the customui14 file with editor i.e., is also no option, same reasons as above.
I would highly appreciate it, if there was anyone who could give me a glimpse, if it is over-all worth it, or if I would be better advised in staying with the Add-Ins controls.
this is kind of my last address to get possible information from, since the msdn post (https://social.msdn.microsoft.com/F...te-ribbon-bar-through-vba-code?forum=exceldev), I started a few days ago, seems to be dead.
my last option would be the book "RibbonX", since I read a lot of good stuff about it, and, on top of that, know, that It has a certain section for my kind of problem ("there is a section that builds a ribbon on the fly in vba") (UtterAccess Forums > Create New Ribbon Category/buttons W/vba).
I know that this text may be pure rape for native speakers, but I am trying my best guys, so please be patient.
thanks in advance guys (!!), feel free to ask anything if I may have missed important information
I am currently optimizing a project system which has about 300 controls, divided in 9 groups (every group has about 5-20 sub menus), currently stored in the 'Add-Ins' tab. Because of usability, I used the custom ui editor in the last days to put this hierarchy into a ribbon bar, which is placed before the Home Tab, and gets loaded when anyone opens the .xlsm file (I call it 'parent-file' in this post). everything works quite fine, the controls are dynamic and users are able to change the language in the menu, when they do, the labels invalidate and get their translated pendant.
now I am on the next stage of this project, as there are certain .doc or .ppt files, which get executed/requested/edited from time to time, and till now, have their 'Add-Ins' controls to do certain things. My question is now: Is it possible to create a ribbon which has like the same characteristics as the one I already created? it should open, as someone executes the .doc/.ppt/..., and close again, when the file is closed (through the vba-procedure, of course). as u could imagine, I am searching the web for something since 3 days. I guess I almost found any possible solution, also tried a lot, but every way got his own issues imo.
to sum this up: First of all: I already know the CUSTOM UI EDITOR! pls do not tell me that it is way easier to edit the ribbon through this neat little program, as it is not practical for the problem I am facing
opening the .xlsm file as a zip and editing the customui14 file with editor i.e., is also no option, same reasons as above.
I would highly appreciate it, if there was anyone who could give me a glimpse, if it is over-all worth it, or if I would be better advised in staying with the Add-Ins controls.
this is kind of my last address to get possible information from, since the msdn post (https://social.msdn.microsoft.com/F...te-ribbon-bar-through-vba-code?forum=exceldev), I started a few days ago, seems to be dead.
my last option would be the book "RibbonX", since I read a lot of good stuff about it, and, on top of that, know, that It has a certain section for my kind of problem ("there is a section that builds a ribbon on the fly in vba") (UtterAccess Forums > Create New Ribbon Category/buttons W/vba).
I know that this text may be pure rape for native speakers, but I am trying my best guys, so please be patient.
thanks in advance guys (!!), feel free to ask anything if I may have missed important information
