Thursday, May 19, 2016 – Permalink –
Change tab names automatically
Changing the names of tabs is easy, just double click the tab or right click and choose rename.
Allen Wyatt has a small piece of code that will automatically update the tab name based on the value of a cell in the spreadsheet.
Sub myTabName() ActiveSheet.Name = ActiveSheet.Range("A1") End Sub
Allen also has some error checking code on his site:
Dynamic Worksheet Tabs
Dick Kusleika suggests another way using a change event:
Naming a sheet based on a cell
See all Topics excel
<Doug Klippert@ 3:30 AM
Comments: Post a Comment