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
 

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