VBA Project Macro Create Button is Greyed out

**Harley51** · 11-06-2024, 01:06 PM

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

**Mumps1** · 11-06-2024, 01:57 PM

It would be easier to help if you could attach a copy of your file so we could see how your data is organized and test possible solutions. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

**Harley51** · 11-06-2024, 11:56 PM

Right now all I want to know is why the create button would be greyed out?

VBA Project Macro Create Button is Greyed out

LinkBack

Thread Tools

Rate This Thread

Display

VBA Project Macro Create Button is Greyed out

Re: VBA Project Macro Create Button is Greyed out

Re: VBA Project Macro Create Button is Greyed out

Thread Information

Users Browsing this Thread

Similar Threads

Macro Button on Quick Access Toolbar Greyed Out

How to create a comment box when the sheet is protected, as insert button is greyed out?

[SOLVED] Opening a ms project file via macro button

create button greyed in macro dialogue

[SOLVED] How do I delete a macro in Excel 2003? Button is greyed out.

[SOLVED] Macro Relative reference button greyed out.

Trust access to visual basic project greyed out

Bookmarks

Bookmarks

Posting Permissions