I would like to increase the font size of the links that populate my index sheet in excel but don't know what the code is or where to put the code. I have tried a few things but none work. Here is my code:

Option Explicit

Private Sub Worksheet_Activate()
Dim wSheet As Worksheet
Dim l As Long

l = 1

Me.Columns(1).ClearContents

With Me.Cells(1, 1)
.Value = "INDEX"
.Name = "Index"
.Font.Bold = True
.Font.Name = "Arial Black"
.Font.Size = 18
End With