Inside the Sort dialog box, beneath Column, inside the Sort by or Then by box, pick out the column you want to sort by a custom list. Recording in the macro commences immediately following clicking the Close button. Perform the actions you want to history and also have the macro https://www.customguide.com/excel/password-protect-excel