Show/Hide Text Box

[#1]

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

[MayilVahanan]

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.

[#3]

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')

[#4]

Thanks for your input; I shall test both.