Buttons to ribbon for a workbook

[drop05]

Hello, i added buttons that hold macros to a customized ribbon but when sending to someone else the buttons are not there, is there a way to have them saved in the workbook so when downloaded its available to others not just myself?

 

[Micron]

What option did you choose when assigning the macro to a button? All, or this workbook only?
If I'm not mistaken, choosing All will store the macro in your Personal xls so not available to everyone. If you chose the other option, then I guess I'm wrong about that. In that case, you might need to export your customizations

Quick Access Toolbar in Excel: how to customize, move and reset

Step-by-step guide to using and customizing Quick Access Toolbar in Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

www.ablebits.com

 

[drop05]

What option did you choose when assigning the macro to a button? All, or this workbook only?
If I'm not mistaken, choosing All will store the macro in your Personal xls so not available to everyone. If you chose the other option, then I guess I'm wrong about that. In that case, you might need to export your customizations

Quick Access Toolbar in Excel: how to customize, move and reset

Step-by-step guide to using and customizing Quick Access Toolbar in Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

www.ablebits.com

i didnt know there was an all selection or this workbook selection, where would that be located at? I assume chose all because its just on my machine, the custom ribbon tab and the buttons within the tab and would like it to be seen by everyone i share it with

 

[Micron]

If you're customizing the QAT then the option is at the top right of pic

 

[RoryA]

See Ron's pages here on creating custom ribbons.

 

[drop05]

If you're customizing the QAT then the option is at the top right of pic
View attachment 76556

This is helpful, but i am doing the customize ribbon not the quick access toolbar