x = ActiveSheet.PivotTables.Count
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Left(ActiveSheet.Name, 3) = "TCD" Then Exit Sub
x = ActiveSheet.PivotTables.Count
If x > 0 Then NomACT = ActiveSheet.Name: If Len(NomACT > 27) Then NomACT = Mid(ActiveSheet.Name, 1, 27): ActiveSheet.Name = "TCD " & NomACT
End Sub