Problem running macro...

[#1]

Hi everybody..

I writed a small macro to sort a straight table in different ways, i also created a button with an action "run macro" to run the previous macro...

But the problem is, when i hit the button instead of run the macro the edit module dialog appears....

Im just beggining using macros and i suspect its a configuration issue because i already checked the macro and it had no errors....

Could you help me out?

Thanks in advance.

[#2]

Under Tools: Edit Module change your security settings to the following and see if it helps:

[#3]

YOu set into a module macro the  OPTION "ACCESSO al sistema " "CONSENTI ACCESSO SISTEMA"(IN ITALIAN). iN ENGLISH I CAN'T TRADUCE. YOU CAN THE SECOND OPTION

[#4]

That translates to System Access > Allow System Access in English

[#5]

I did as you instructed me and still having the same problem... coul it be anything else?

[#6]

TH FILE IS LOAD IN A  ACCESPOINT OR LOCAL ?

CAN YOU PASS ME A FILE ?

[#7]

Did you confirm that the name of the macro is identical to the name of the macro in the button action? Other than the macro itself containing an error, that's all I can think of. Marco, do you have any ideas?

[#8]

Yes its the same name, here are the screenshots:

(Of the macro)

()

And the button:

All the datasources are local(in hard drive) excel sheets since i'm developing the aplication in a laptop.

[#9]

Same happned to me, and I found that there was an error in my macro code. So fixed the error, and all worked fine.