Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon everyone,
I am really interested with the charts "Set Reference" functionality, very useful when you want to compare 2 situations corresponding to differnt selections on the same chart. As I can't use this functionality on iPad and Web browsers (not present in Menu icon and impossible to simulate the right-click from an iPad), I was wondering about programing this with VBScript or JScript and call it from a button with a "call module" action.
Anyone ever programmed this before?
Thanks in advance.
Regards.
Chris.
Here is the solution:
use a macro in the module (Tools/Edit module)
To set a reference:
...
Sub setReference
set Graph = ActiveDocument.getSheetObject("CH383")
Graph.SetReference
end sub
...
To Clear a reference:
Sub clearReference
set Graph = ActiveDocument.getSheetObject("CH383")
Graph.ClearReference
end sub
...
Then, call macros from a button action.
Chris