Any ideas on how I can force a single sheet to convert to all caps upon opening & closing a workbook? I'm currently using:
Private Sub Worksheet_Change(ByVal Target As Range)Target = UCase(Target)
End Sub In the active sheet but it is somewhat "laggy".