Issue with button not running in spread sheet only in test mode

[PA_VA13]

Hi everyone! I have a button I created called 'BOLD UNDERLINE' that for some reason will not do anything when I click on it in the spread sheet. It only works when I click on the play/run macro button in the Visual Basic code writing window when testing. What am I missing.

Sub underline()
'
' underline Macro
' bold underline of selected row (30 columns)
'
' Keyboard Shortcut: Ctrl+l
'
Range("A" & Selection.Row & ":AA" & Selection.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
End Sub

 

[6StringJazzer]

Hard to say for sure without examining your button, but it's the button, not the code.

What kind of button is it? Form button, ActiveX button, shape, image?

How did you associate the button with this code?