Dave,
Thanks for your time.
MacroC is:
-------------------------------------------------------------------
Sub AllSetFileProps(control As IRibbonControl)

Application.Run (ClearFileProps)

Application.Run (FillFilePropsComments)

Range("C5").Select

End Sub
-----------------------------------------------------------------------


"Dave Peterson" wrote:

Maybe it's time to share what MacroC looks like.

And maybe you should look for macros with duplicate names (in different
modules).

SteveDB1 wrote:

Ok, it appears that this is either too vague, or not understood.
Let me see if I can revise it some to clarify.
I have three macros.
MacroA, MacroB, and MacroC.
MacroA, and MacroB each perform a unique task, and work well.
MacroC has one job-- to access, and perform the task of both MacroA, and
MacroB, in order. Sample below.

Sub MacroC(control As IRibbonControl)
Application.run "MacroA"
Application.run "MacroB"

Range("c:5").select

end Sub

When I access MacroC, I get an error window, as stated before-- Argument not
optional error449. When I click debug, it takes me to the first
application.run "MacroA".
What is it that I've done wrong, and how can I correct it because I have at
least 6 or so macros that are similar to this one.
As always, in advance, thank you for your responses.
Best.

"SteveDB1" wrote:

Hello all.
One of my colleagues has a series of macros. In these macros he has a series
of calls-- application.run-- that call to activate a secondary, or series of
tertiary macros.
However, I keep getting the argument not optional error449.
This has lead me to think that Excel 2007 no longer uses that object event
handler.
Does anyone know the replacement, or new version of that command?
As always, your responses are deeply appreciated.
Thank you in advance.


--

Dave Peterson