excel Run Macro error

[Murph]

I've set the security options in Excel to Trust access to Visual Basic Project to checked and even reduced Security level to Low but still when I try to run a macro (which works from the spreadsheet) from LV2009 it gives a -2146827284 error, can't find macro.

Attached is my LV .vi and the image of the error window.

I must be missing something very simple but can't find it.

[RavensFan]

What module is your program being imported into?

I'm wondering if you are not fully qualifying the name of the macro.  Assuming the macro gets created in Module 1, what happens if you tried Module1.Sort in your macro name control instead of just Sort?

[Murph]

Thank you. 

I had tried that but just tried it again as Module4.Macro1. (See attached screen capture).

Frustrating, this is holding up a large application.