Tabs

Hi Shadé,

Thank you for the forum question.


You can achieve this in Excel using a bit of VBA (Visual Basic for Applications) scripting. Here’s a simple script that will automatically renumber your tabs when you insert a new one:

Press Alt + F11 to open the VBA editor.
Insert a new module by clicking Insert > Module.
Copy and paste the following code into the module:
Sub RenumberTabs()
Dim ws As Worksheet
Dim i As Integer
i = 1
For Each ws In ThisWorkbook.Worksheets
ws.Name = i
i = i + 1
Next ws
End Sub

Close the VBA editor.
Run the script by pressing Alt + F8, selecting RenumberTabs, and clicking Run.
This script will go through all the worksheets in your workbook and rename them sequentially starting from 1. If you insert a new tab and run the script again, it will automatically adjust the numbering.





Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector