Hello, I am trying to create a shadow effect on a button I am creating using vba and have tried for hours with no success. Here are the two versions of code that I have been using to do this.
If ActiveSheet.Name = "204 (2)" Then
ActiveSheet.Buttons.Add(628, 48, 72, 26).Select
Selection.Name = "Remove 204"
Selection.Font.Bold = True
Selection.OnAction = "Remove_204"
ActiveSheet.Shapes("Remove 204").Select
Selection.Characters.Text = "Remove 204"
' Selection.Shadow = True
End If
If ActiveSheet.Name = "204 (2)" Then
Set btn = ActiveSheet.Buttons.Add(628, 48, 72, 26)
With btn
.OnAction = "Remove_204"
.Caption = "Remove 204"
.Font.Size = 11
.Font.Bold = True
' .Shadow = True
End With
End If
I can't figure it out using either method. Where have I gone wrong?
Gary