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.
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.
Source : Excel customize commandbar