This is my first reply to a post here, so forgive me if the formatting
isn't the usual.
Here's one example of what you can do. From what i know of VBA the
easiest way would be to use the "Sheet2.Name" to alter the sheets
tab-name.
Everytime you enter a new name into A1, B1 etc. the change refreshes
the tab names.
Not very elegant, but it works.
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet2.Name = Sheets("Control").Range("A1").Value
Sheet3.Name = Sheets("Control").Range("B1").Value
End Sub
---
Message posted from
http://www.ExcelForum.com/