Results 1 to 3 of 3

Thread: Chnage name of worksheet tab based on cell

  1. #1

    Chnage name of worksheet tab based on cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, i am having trouble trying to figure out how to change the name of the tabs to correspond with the month along with the day based off a cell in each worksheet.


    thank you

  2. #2
    Change the tab name in the Workbook_SheetChange event.

  3. #3
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    151
    Articles
    0
    Excel Version
    2007
    .
    Code:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Me.Name = Me.Cells(1, 1).Value
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •