I inserted the following code for each worksheet tab to dynamically change
the sheet name to match the value in the designated target cell in that
worksheet:

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


It works OK with one quirk that I don't know how to fix.

When I change the value in the target worksheet cell (C7), the worksheet tab
name does not change until I click on another worksheet tab, then click back
on the worksheet tab I just changed.

How do I make the tab name change as soon as the target cell is updated ?

Thanks !!!
--
HOOS77