Forum Discussion
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...
There is a command named Sheet Name:
However, its function is to add the sheet name to the header or footer of the sheet. I suspect that's not what you wanted...
- thanks but it is not. i am want to call worksheets from the custom ribbon. maybe VBA code will work.
You need VBA and RibbonXML. See Excel Navigator List and Sort Sheets
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
