hi anandrjs, thanks for your reply,the sheet object got no maximize trigger, so i have to resort to button to make this funcion work.
user got a lot of bar chart, and a lot of bars in these charts, they want to see a full view of all values when they maximize these charts and dont want to see too many values when the chart is under small size. i create a macro to trigger this funciton ,that is to set max number in chart to a lager number when the chart is been maximized and a small number when the chart been restored. the problem is when i click the maximized chart, the button disapeard.
From your question what i understand is the chart and button shuold display both at a time.
Try for the Chart -->Layer = Bottom
Button --> Layer = Normal.
Before doing this first place the chart at certain place and set the Layer = Bottom.
Now you can place Button over the chart and set the Layer = Normal.
Hope this helps you.