•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to sort tabs using an Office Script instead of VBA
Is there an Office Script that will sort all of the tabs in a workbook alphabetically but ignore certain tabs?
I have a VBA script that will do the job, but I don't want to use VBA anymore.
Example I have a workbook with employee last names, one tab for each employee. There are about 60 tabs. I also have a summary tab at the start of the workbook. When I add a new employee tab, I have to move it to the right place alphabetically. It would be nice to have a Office Script Automated Button that will just resort all the tabs, but leave the Summary tab as the first tab, not sort it to the "S".
[link] [comments]
Want to read more?
Check out the full article on the original site