jsach's blog
Increase font size of links
Submitted by jsach on 18 October, 2012 - 17:54I 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
»
- 4 comments
- Read more
- 5138 reads
Recent comments
5 years 27 weeks ago
6 years 13 weeks ago
6 years 25 weeks ago
6 years 28 weeks ago
6 years 29 weeks ago
6 years 34 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago