Hi,
I wish to run these two codes when i open the worksheet MC LIST.
Private Sub Worksheet_Activate() Range("A6").Select
Range("A4:G4").Font.Size = 24
Range("A6:G40").Font.Size = 18
Range("A4:G40").Font.Bold = True
Range("A4:G40").Font.ColorIndex = 1...