Download the featured code here: https://www.bluepecantraining.com/wp-content/uploads/2024/03/sort-worksheets-code.txt
In this Microsoft Excel video tutorial I explain how to use VBA macros to sort worksheets by their tab name, either alphabetically or numerically. The video also explains how to save these macros to the Personal Macro Workbook so that they are available to all workbooks. Lastly, I demonstrate how to run the macros via custom buttons on Excel's ribbon.
️Timestamps
00:00 Introduction
00:34 Open the Visual Basic Editor (VBE)
01:12 Pase the code into the VBE
01:50 Explanation of the VBA code
03:56 Running the code from inside the VBE
04:53 Saving the code to the Personal Macro Workbook
06:43 Create buttons on the Ribbon to run the macros
#exceltips #excelvba #excelvbatutorial #exceltutorial #exceltricks