Results 1 to 4 of 4

Thread: Auto naming tabs?

  1. #1
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    26
    Articles
    0
    Excel Version
    1901

    Auto naming tabs?



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

    Hello Gurus,

    Is there a way to enter information into a cell and it auto populate the name of that tab?

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013

    auto populate tab name from cell

    Quote Originally Posted by bobjglover@gmail.com View Post
    a cell and it auto populate the name of that tab?
    This VBA macro you copy in 'ThisWorkbook' module of your Workbook
    Code:
    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Target.Address = "$A$1" Then 'adress of cell where is name of sheet
    ActiveSheet.Name = [A1]
    End If
    End Sub
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    26
    Articles
    0
    Excel Version
    1901
    Ty, where is'this workbook module' located? In the same workbook?

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by bobjglover@gmail.com View Post
    Ty, where is'this workbook module' located? In the same workbook?
    Yes, in the same workbook
    I gave you the link (post up above)
    Look at the 5th image

    btw:
    - Right-click on the some tab name
    - pop-up menu => View code
    - In the VBE you can see "ThisWorkbook" module, below the sheet name (Excel 2013)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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