la fonction Proper met chaque debut de chaques mots en majuscule, faudrait changer de méthode, j'ai essayé avec des left et right:
Option Explicit
'*** CODE PREMIERE LETTRE (MAJUSCULE GRAS et ROUGE) A PARTIR DE "A4:A1300" SUR TOUTE LA COLONNE "A"
Sub Majusc()
Dim Lg%, Cel As Range
Dim i As Integer
Lg = Range("A1300").End(xlUp).Row
Application.ScreenUpdating = False
With Range("a4:a" & Lg).Font
.Name = "Calibri"
.ColorIndex = 1
.Size = 9
End With
For Each Cel In Range("a4:a" & Lg)
For i = 1 To Len(Cel.Value)
If Not IsNumeric(Mid(Cel, i, 1)) And Not Mid(Cel, i, 1) = " " Then
'Si on est rendu au point, quitte la boucle
If Mid(Cel, i, 1) = "." Then Exit For
Cel = Left(Cel, i - 1) & UCase(Mid(Cel, i, 1)) & Right(Cel, Len(Cel) - i)
With Cel.Characters(Start:=i, Length:=1).Font
.ColorIndex = 3
.Bold = True
.Size = 11
End With
Exit For
End If
Next i
Next Cel
End Sub