View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Ribbon Macro does not work when stored in Personal file

Hi Roland

Try this in a macro in the add-in

dim iRCdummy as IRibbonControl
Application.Run "Personal.xlb!MyMacro", iRCdummy


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Roland" wrote in message ...
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'.

"Barb Reinhardt" wrote:

I've not had issues with my Personal file when I updated the ribbon using
instructions here

http://www.rondebruin.nl/ribbon.htm



"Roland" wrote:

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