dynamic sheet tab names?

hi

i would like the name of the worksheet to refer to a cell within the sheet, the month that the user selects from a dropdown menu?! cell C1. can this be done?!

cheers

millsy

This workbook changes the name of the first tab to whatever is in cell A1.

that works!
brilliant

cheers
millsy

Hi, If your Drop down Box is from the "forms" menu and it is filled with Months of the Year, then you can use this.

Please Login or Register  to view this content.

Regards Mick

Hi,

The below given code will change the title of each sheet in the worksheet to whatever is in cell c1 of that sheet.

Public Sub mysheet()

Dim ws As Worksheet
Dim shtName As String

For Each ws In Worksheets

shtName = ws.Name
ws.Select
Sheets(shtName).Name = Range("c1").Value

Next ws

End Sub

Originally Posted by wmorrison49

This workbook changes the name of the first tab to whatever is in cell A1.

Hello! I've tried simply copying and pasting the code into other worksheets, but that doesn't seem to do it. Is there something I need to enable in each sheet for this to work? Sheet one works just as hoped, changing upon enter. When I try to replicate this in sheets 2 and three, the name doesn't change.

Thanks!