Looking to make custom Ribbon buttons

akatsuki

New Member
Joined
Jun 19, 2012
Messages
15
Any really for idiots guide to making custom Ribbon buttons?

I'd like one that toggles between "Center Across Selection" on and off.

Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button.

Is this possible? I downloaded the Spreadsheet Guru's CAS button, and it works, but replaces the entire grouping there.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
You can add any existing buttons or commands to a custom Ribbon or any Macros to a Ribbon as Buttons.
You can also set what is the primary Ribbon by changing the order the ribbons appear.
You are even able to replace all the ribbons, except the context ribbons, with your own custom versions.

Your question, to me, is more about two macros that cause your desired actions.

Don't forget the option of using the Quick Access Toolbar or QAT
 

Watch MrExcel Video

Forum statistics

Threads
1,114,506
Messages
5,548,465
Members
410,838
Latest member
naydeenmonzon
Top