MACRO RUNS FROM "TEST" BUT DOESN'T FROM THE BUTTON CREATED

[#1]

Hi everyone! just incurred in a very odd situation...

I'm running 5 macros, each composed of 3 macros in sequence. the problem is that the first button (which is supposed to run 3 macros) it actually runs only the first and the second one. But when I enter the modul and I "test" the third macros, it runs! (check the attachment for a better understanding)

I know that macro is fine, since it runs on the other reports and also when i test it. So...any ideas??

Many thanks!!!

Messaggio modificato da Irene Franceschini

[MK_QSL]

make sure that under EDIT MODULE below should be there..

[#3]

Manish Kachhia I have already set the correct settings. Indeed the other buttons (and their macros) run correctly! It's just the first button which doesn't work from the button, but only if triggered by the "test"

[#4]

Just for everyone's reference, please note that i have already tried below trouble shoots:-

1. Tried "onpostreload" and "onopen"
2. "macro override security" is checked in Security
3. "Module" and "file" is checked in user preference >> settings
4. Tried /l instead of /r in batch reload
5. Tried on open with a trigger in Property documents/Trigger/on Open

Any other suggestion?????

[#5]

Ciao Alice,

ma stai testando l'esecuzione in locale o su un access point?

[#6]

In locale

[#7]

Se sei in locale, prova a mettere l'esecuzione di ogni singola macro su un tasto solo, del tipo:

Button 1-> Macro 1

Button 2-> Macro 2

Button 3-> Macro 3

Button 4-> Macro 4

Button 5-> Macro 5

e se proprio devi eseguire 2 macro con lo stesso tasto, fai richiamare la Macro 2 direttamente all'interno della macro 1 nel codice VB, e non con 2 action.

[vikasmahajan]

There might in small syntax error in your macro !!

Vikas

[#9]

no errors...the same macro works in the other 4 buttons

[#10 · Accepted solution]

I solved it! I still don't know what was wrong thoug...I just cancelled the button and re-created it; in the macro I changed the reference to the chart from CH698 to CH703 et voilà! btw...thanks anyone who tried to help me!