Forum Discussion
Solved
Custimising Ribbon
My machine uses Windows 10 and Excel 2019. I am aiming to add a dozen or so custom buttons to the Ribbon to invoke some macros that have been tried and tested on Excel 2000. As simple trial of the p...
GregoryGoon , Hi, i think you need to write full address of the macro in the xml.
Something like :-
onAction="'C:\....path of personal.xlsb.....\Personal.xlsb'!HelloWorld_2"
Most possibly, the complete path is as below :-
onAction="'C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\XLStart\Personal.xlsb'!HelloWorld_2"
where user name is your windows account name
GregoryGoon , Hi, i think you need to write full address of the macro in the xml.
Something like :-
onAction="'C:\....path of personal.xlsb.....\Personal.xlsb'!HelloWorld_2"
Most possibly, the complete path is as below :-
onAction="'C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\XLStart\Personal.xlsb'!HelloWorld_2"
where user name is your windows account name