I have a VBA Project that I want to create a update module Macro. When run my VBA project and I go to macros my create chose is greyed out. Here’s an example of what I want to do. See want I want to change in red.
Sub Top10Mega4()

If (Range("G11").Value = 9) Then

Range("AS6").Select
ActiveCell.Value = ("1")

ElseIf (Range("G11").Value = 6) Then (Change 6 to a 9)

Range("AS6").Select
ActiveCell.Value = ("1")

ElseIf (Range("G11").Value = 24) Then Then (Change 24 to a 10)

Range("AS6").Select
ActiveCell.Value = ("1")

ElseIf (Range("G11").Value = 11) Then

Range("AS6").Select
ActiveCell.Value = ("1")

End If
End Sub