Change value without opeing tab

[judgejustin]

I am using the following code to change the name of a tab dependent on cell values. However it only updates if I leave the tab and come back to it. I would like it to update immediately upon the information in the cells changing.

Private Sub Worksheet_Activate()
ActiveSheet.Name = ("Stage 1 #1  ") & ("(") & ActiveSheet.Range("B8") & ("-") & ActiveSheet.Range("C8") & (")")
     
End Sub

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Not Intersect(Target, Range("B8:C8")) Is Nothing Then
      ActiveSheet.Name = ("Stage 1 [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL]   ") & ("(") & ActiveSheet.Range("B8") & ("-") & ActiveSheet.Range("C8") & (")")
   End If
End Sub

 

[judgejustin]

Unfortunately that code does not update at all.

 

[Fluff]

How are B8 & C8 being changed?
Manually, data validation, Formulae?

 

[judgejustin]

They are formulas.

 

[Fluff]

OK, how about

Private Sub Worksheet_Calculate()
   ActiveSheet.Name = ("Stage 1 [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL]    ") & ("(") & ActiveSheet.Range("B8") & ("-") & ActiveSheet.Range("C8") & (")")
End Sub

This will fire every time the sheet calculates

 

[judgejustin]

For some reason this is now interfering with another macro that is running. It is trying to rename a sheet that opens with that other macro. I will just keep it the way it is. Thank you for the code though I have it saved because I plan to use it on a different sheet that doesn't have these other macros running on them.