Macro on table

[filippo]

Hi Community,

I have a question about the activation of a macro:

Can you attach a macro to a cycling group in a table?

so that when changing the dimensions of cycling group macro is activated.

Thanks

[separerl]

Hi

I downloaded Robs sample , but in my case , the Macro is never fired , the msgbox never appears.
It changes the text object , but it never runs the Macro.

Any ideas ?

Best regards
Pär

[#3]

Hello Rob,

I have a chart with fast change (Straight and Pivot) which is created dynamically. It contains many dimensions and one of them is a cyclic group which displays field (Date and Month-Year) . This chart is linked to a macro so that when users adds or removes dimensions it returns the number of row count.

Issue: When switching from Month-Year to Date in cyclic group, I cannot find a way to trigger the macro to run that does the row count.

Attached you will find my sample application.

Any suggestions will be appreciated.