Excel Transfer of customized excel tabs with UI Editor but VBA code not working

Joined
Sep 24, 2016
Messages
1
Reaction score
0
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
 
Back
Top