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 the right pane of the Excel Options dialog box, click on New Tab.
- Rename the new tab as per your preference.
- Click on New Group.
- Rename the new group as per your preference.
- Click on Choose Commands From and select All Commands.
- Scroll down and select Worksheet Name.
- Click on Add and then click on OK.
However on step 8 there seems to no option to Add Worksheet name.
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
