Host your Web site with PureHost! |
![]() ![]() Wednesday, September 02, 2009 – Permalink – Dynamic TabsChange tab names automaticallyChanging 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 [Edited entry from 8/3/2006] See all Topics Labels: Excel <Doug Klippert@ 6:28 AM |