Running a Macro in one workbook from another workbook

[Saladsamurai]

If Analyze_Clixk is a procedure, what makes you think it has a Value property?

That fact that Dave Peterson says so.

I am not a programmer, so I don't even know what that means. I just say to myself: "Self, what do you need to do today? Okay then! You better Google that $hit!"

Know what I mean?

But back on track here.....if it does not have a value, like you seem to be implying, then why does [VBA]Workbooks(WorkBookNames(0)).Worksheets("Viewer").Analyze_Click.Value = True [/VBA] actually run the routine (like it clicked the button for me)?



More importantly why does the line that you originally gave me :

Application.Run "20LW6_TEST_redo!Analyze_Click"

not work if I made Analyze_Click Public?

I even created a New Public Sub called Mixed() and put it in "20LW6_TEST_redo" in a module and tried calling that using

Application.Run "20LW6_TEST_redo!Mixed"

But AGAIN Excel says it can't find it....what the hell is its problem.