Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 graph in Container ,
when i open this container open in the last select graph,
there is any option to open in specific graph always in this specif container.
I atacha a qvw.
Maybe you can save a bookmark with the state of the sheet (and not the selection) and trigger to apply the bookmark each ime you select the sheet
If you want to use buttons and macros, you have a property of a container to set which graph you want to be active :
you can use somth similar to this piece of code (this is to know which tab is selected) :
Set ContainerObj= ActiveDocument.GetSheetObject("CT01") '
set ContProp=ContainerObj.GetProperties 'get index of currently active tab/object of container
activeIndex= ContProp.SingleObjectActiveIndex
if activeIndex=0 then
...
i can´t use macros, that is no a solution for my boss.
when i change sheet, i need open specif chart inside the contendor. no the last selection in that contendor.
You now that ??
Thanks,
Maybe you can save a bookmark with the state of the sheet (and not the selection) and trigger to apply the bookmark each ime you select the sheet
I TRIED TO DO IT, AND DON´T WORK, IN THE SPECIFIC SHEET IT WORKS, BUT, IN TRIGGER ON ACTIVE SHEET NOT CHANGE.
THANKS FOR THE SUGGESTION!
ANY BODY TELL ME SOMETHING MORE TO SOLVE MY PROBLEM??
THANKS
you have been careful to put the ID of the bookmark ? and not the name ? I have made that mistake myself
YES, NOW WORK IT,
THANKS,
10 POINT FOR YOU!