Forum Discussion
mrainier
Jul 10, 2023Copper Contributor
Costomize ribbon to include Worksheet names
I have been tring to add the Worksheet Names to the ribbon, followed these instructions Click on File and then click on Options. In the Excel Options dialog box, click on Customize Ribbon. In th...
mrainier
Jul 10, 2023Copper Contributor
thanks but it is not. i am want to call worksheets from the custom ribbon. maybe VBA code will work.
HansVogelaar
Jul 10, 2023MVP
You need VBA and RibbonXML. See Excel Navigator List and Sort Sheets
- mike_rainierJul 11, 2023Copper Contributor
this worked well for me. record a macro.
select the worksheet and make desired modifications.
stop recording.
in custom ribbon create group name.on left side select commands, macros
add macro name to group name
works