kadrleyn
Member
I created a new command bar using the macro, we added two buttons and a drop-down list to this command bar.
Each control in the command bar triggers a macro.
The worksheets are listed in the drop-down list. With the Update button, the drop-down list is updated, with the Sort button, the sheets in the drop-down list are sorted alphabetically.
![76852 76852](https://chandoo.org/forum/data/attachments/76/76944-a247502203c41054dbc89462bd42ac59.jpg)
Source : Excel customize commandbar
Each control in the command bar triggers a macro.
The worksheets are listed in the drop-down list. With the Update button, the drop-down list is updated, with the Sort button, the sheets in the drop-down list are sorted alphabetically.
![76852 76852](https://chandoo.org/forum/data/attachments/76/76944-a247502203c41054dbc89462bd42ac59.jpg)
Source : Excel customize commandbar