Macro not available to execute from this workbook.

I have two macros (both public) in the this workbook section of vb.  When I open the spreadsheet, one is available to execute but the other is not.  Why?
ilrosebud26Asked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
If you mean that they aren't visible from the Tools/Macro menu, the list will not show subs that need a parameter or any functions.
0
 
GrahamSkanRetiredCommented:
What happens when you try to execute it?
0
 
ilrosebud26Author Commented:
When I first open the workbook and try to launch from the menu, the run option is not available.  If I save the file after it is open, the macro name changes and the run button is then available.
0
 
ilrosebud26Author Commented:
Here is the macro....I do not think there is anything that needs a parameter or function.  

Rosemary
Public Sub DeleteMenu()
    On Error Resume Next
    Application.CommandBars("Worksheet Menu Bar").Controls("Marketing Cost").Delete
    On Error GoTo 0
End Sub

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.