Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Ive been looking for the forum and cant quite find what im looking for.
Is it possible to show a text box when a chart is opened and hide the box when the chart is minimised?
I have been trying with the conditional show on the text box without any joy.
Cheers
Hi
Try like this in button -> Run macro -> test
use vhide in show conditional in layout properties in textbox.
sub test
set v =ActiveDocument.Variables("vhide")
if ActiveDocument.GetSheetObject("CH02").IsMinimized then
ActiveDocument.GetSheetObject("CH02").Maximize
v.SetContent "1",true
else
ActiveDocument.GetSheetObject("CH02").Minimize
v.SetContent "0",true
end if
end sub
I think it helps or give idea how to hide or show the textbox ..I tried in button to minimize and maximize the chart at the same time to show and hide the text box.
Hi
Try This One by using the Button we Can show/hide by creating The Varibale .
Button->P.P->Actuins->External->Setvariable
In the Vatible(ctrl+Alt+V)
we can create like
=if(Vhidedatapoints='Hide','Show')
Thanks for your input; I shall test both.