Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    16

    Unanswered: tab names and updates

    i am using excel 2003 and i have a total sheet in my workbook that i have setup to do automatic updating using this formula: =SUM('[Client1]Client 1'!I37). my problem is that the cell is not updating automatically. i have to reisert the formula to get it work, is there something i can do to fix this?

    also is there any code available that will allow me to change the tab names when a cell in the sheet is changed? in other words if someone adds a new client is there someway for the tab name to automatically change to that name? if so how can i do it?

    thanks,
    knottrodney

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    For the first part, check Tools > Options > Calculation and make sure it is set to automatic

    For the second part, you can change the names of tab in code several ways. Each worksheet is a Sheet object and can be referenced using it's index or it's name. The desired property, as expected, is Name

    Code:
    Sheets("Sheet2").Name = "NewName"
    As for the "automatically" part, you have to decide what the trigger is and where to put the code.

    tc

    ------> Edit <------

    Your formula is set to sum one cell, in a worksheet with brackets in it's name, which Excel 2003 does not allow. Rename your worksheet and try again.

Posting Permissions

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