sheet labels
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: sheet labels

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there a way to put a formula in a sheet tab? I want to label a sheet with the data in a specific cell.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    On 2002-03-20 11:27, jstritch wrote:
    Is there a way to put a formula in a sheet tab?

    sadley i do not think so .

    Fis i use row 1 as dumping ground fpr such detail so never delete row 1 (Chris D)
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Of course there is a way

    Open the code designer and double click on the sheet object which you want to try naming then paste this code.

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    On Error Resume Next
    If Target.Address = "$A$1" Then Sheet1.Name = Target
    If Err Then Target = ActiveSheet.Name
    End Sub

    A worksheet's Name property means Label on Worksheets Tab.

    Error handling stands for avoid names.

    A1 cell used as the label source.

    This code will be executed everytime cell A1 changed then if the text value in A1 is allowed to use as the sheet name then sheet name on the tab would be changed.

    Regards

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com