Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Macro does not work when stored in Personal file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Macro does not work when stored in Personal file
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Macro does not work when stored in Personal file
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon Macro does not work when stored in Personal file
thanx Ron, this works
there's also the opportunity to not store macros in the Personal file but use addins regards roland "Ron de Bruin" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/unhide personal ribbon tab. | Excel Programming | |||
Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work | Excel Programming | |||
Macro in personal.xls does not work | Excel Discussion (Misc queries) | |||
Macros stored on Personal.xls | Excel Programming |