Change object layer value when clicking on it

[Miguel_Angel_Baeyens]

Hi everyone!

I have some QV documents with several minimzed charts "grouped" with a transparent textbox over them so if you click on the minimized icon you are actually clicking on the textbox, with executes a macro. So far, so good.

Now, some of these charts may be maximized. If I change the layer to "Top" or custom above "1", when the chart is minimized, it won't be possible to "group" under the textbox. If I change the layer to Top in the textboxes, when maximized, the chart will be under those textboxes.

I was trying to find out how to change possible layer values with a macro, but I don't know how to do it.

Any ideas or suggestions will be appreciated!

[#2]

The query is not clear...:(
Why do you need to place a transparent text box on top of the charts?
If that triggers a macro, then it must be a button and not a tect box.

Can you please ellaborate you query brother?

[#3 · Accepted solution]

try if you can incorporate this in you rmacro

ActiveDocument.GetSheetObject("CH01").SetLayer 1

parameters are

-1 bottom

0 normal

1 top

regards

peter

[Miguel_Angel_Baeyens]

Thanks Peter, that was I was looking for.