Hi, all
I want to transfer some customized tabs on the excel ribbon from 1 excel file to another. I have managed to transfer the actual tabs by using Custom UI Editor so my ribbon is now containing all tabs from the old file, however, when I try to use the tabs I get a message " Cannot run the macro, it is not available in this workbook". When I go into VBA editor of the old book I have only one module with RibonX code (which is very short and I am not exactly sure what it is supposed to do) which I have copied to the new work book ....however the tabs/functions are still not working....
Any ideas what could be causing the problem?
thanks
I want to transfer some customized tabs on the excel ribbon from 1 excel file to another. I have managed to transfer the actual tabs by using Custom UI Editor so my ribbon is now containing all tabs from the old file, however, when I try to use the tabs I get a message " Cannot run the macro, it is not available in this workbook". When I go into VBA editor of the old book I have only one module with RibonX code (which is very short and I am not exactly sure what it is supposed to do) which I have copied to the new work book ....however the tabs/functions are still not working....
Any ideas what could be causing the problem?
thanks