Forum Discussion

swelch's avatar
swelch
Copper Contributor
Oct 23, 2017

Link Worksheet Tab

How can I link a worksheet tab to a cell?

excel

1 Reply

  • Michael_Avidan's avatar
    Michael_Avidan
    MVP
    Nov 02, 2017

    swelch,
    I just finished writting and posting some code for your similar question regarding 3 days a week sheet tabs.
    The answer to your above question is to use a WorkSheet Event-Macro.
    Any change to cell A1 will be reflected in the Sheets Name.
    *** Remeber that Sheets Names are limited and do not aloow special characters etc'
    -------------------------------------------------------------

    Private Sub Worksheet_Change(ByVal Target As Range)
     On Error Resume Next
     ActiveSheet.Name = [A1]
End Sub

    Michael (Micky) Avidan
    “Microsoft® Answers" - Wiki author & Forums Moderator
    “Microsoft®” Excel MVP – Excel     (2009-2018)
    ISRAEL