Ribbon Macro does not work when stored in Personal file

  • Thread starter Thread starter Roland
  • Start date Start date
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
 
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'.
 
thanx Ron, this works
there's also the opportunity to not store macros in the Personal file but
use addins
regards
roland
 
Back
Top