Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Thursday, August 03, 2006 – Permalink –

Dynamic Tabs

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

See all Topics

<Doug Klippert@ 8:04 AM

Comments:

Here's another way: http://www.dailydoseofexcel.com/archives/2005/01/04/naming-a-sheet-based-on-a-cell/

# posted by

Dick Kusleika : 8/04/2006

I like the idea of using a Change event.
Thank you!

# posted by

Doug Klippert : 8/04/2006

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link