A spreadsheet has grown over time. It has now so many tabs that it is difficult to find what you need.
I have therefore introduced a 'Contents' page with Command Buttons on each row to take the user to the correct sheet.
To make life even easier, I want to sort the contents alphabetically, but how can I also sort the Command Buttons ?
When I do a sort, the buttoms remain unsorted & thus irrelevant
I have therefore introduced a 'Contents' page with Command Buttons on each row to take the user to the correct sheet.
To make life even easier, I want to sort the contents alphabetically, but how can I also sort the Command Buttons ?
When I do a sort, the buttoms remain unsorted & thus irrelevant