Ribbon Macro does not work when stored in Personal file

R

Roland

I have a ribbon bar with icons that activates a macro stored in add-in files.
Also in the Personal.xlsb file are some macros stored, but they do not work
on activation of ribbon buttons..
When I transfere one of these to an add-in, it does work.
What's wrong with the Personal ?
roland
 
R

Roland

I have used Ron's instructions as well, but encounter the Personal files'
problem.
It might have something to do with disabled macros. This is the message I
get; 'Macro is not available in this workbook are may be disabled'.
 
R

Roland

thanx Ron, this works
there's also the opportunity to not store macros in the Personal file but
use addins
regards
roland
 

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