Dynamicly change spreadsheet tab names depending on cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to change tab names dynamicaly ? For example i have 31 tab (1
for each day of the month)

These tabs are named - 1,2,3 e.t.c
Is it possible to define rule that would ad "!" to day which is weekend day.

In other words is it possible to dynamicly change tab name depending from
value of cell ?

If this is possbile how do i do this ?
 
Right-click on the spreadsheet tab, select View Code and paste this in:-

Private Sub Worksheet_Activate()
ActiveSheet.Name = Range("A1").Value
End Sub

To test this I put the date in cell B2 and this formula into A1:-

=TEXT(DAY(B1),"d")&IF(OR(WEEKDAY(B1)=7,WEEKDAY(B1)=1),"!","")
 
bigwheel .....

This was exactly what I was looking for & it works fine with one relatively
minor oddity (to me anyway since I'm not a programmer). When I change the
value in the target worksheet cell, the worksheet tab name does not change
until I click on another worksheet tab, then click back on the tab for the
worksheet whose tab name I was trying to change. How do you make the tab
name change as soon as you update the target cell ? It's not a showstopper,
but it would be less confusing if this could be fixed.

Thanks !!!
 
Back
Top