GenjutsuGhost
GenjutsuGhost

Reputation: 47

How do I remove Underline from whole worksheet?

I would like to remove all Underline in my worksheet and I would like to use a macro for this.

I could only find this code, which adds Underline.

Worksheets("Sheet1").Activate 
ActiveCell.Font.Underline = xlUnderlineStyleSingle

Upvotes: 0

Views: 2238

Answers (1)

Tim Williams
Tim Williams

Reputation: 166825

Like this:

ActiveWorkbook.Worksheets("Sheet1").UsedRange.Font.Underline = False

Upvotes: 5

Related Questions