Detect Hidding Event ?

[e-me]

Hi,

I'm searching a way to detect when the user is hidding or showing a row or a column, could anyone help me ?

Thanks in advance.

[Carim]

Hi,

There is no event per say to capture hidding or showing ...
You would have to think about the context to find a solution ...probably with selection_change ...

[e-me]

There is no event per say to capture hidding or showing ...
You would have to think about the context to find a solution ...probably with selection_change ...

They haven't think to raise en event when excel shows or hides a row or a column .!

What do you think exactly?

[antoka05]

You can try with this code:

Please Login or Register  to view this content.

I hope it's what you need.

Regards,
Antonio

[e-me]

I don't really understand your code : this is only for reading hidden columns and rows, isn't it? The code can't react when a row or a column is hidden?

[e-me]

Any ideas, please?