1. In your docuument, define a variable named "vShowSheet" and assign it a value of "1".
2. On the properties General tab for the sheet(s) you want hide, in the Show Sheet section: - check Conditional - Enter "vShowSheet" for the Condition (without the quotes).
3. If you are using V9+, assign Action to the button: Action: Set Variable Variable: vShowSheet Value: =(vShowSheet-1)*-1
That Value expression will toggle the variable value between 0 and 1.
3 If you are using V8, define a macro like this: Sub ToggleShow ActiveDocument.GetVariable("vShowSheet").SetContent ActiveDocument.Evaluate("(vShowSheet-1)*-1"), true End Sub
1. In your docuument, define a variable named "vShowSheet" and assign it a value of "1".
2. On the properties General tab for the sheet(s) you want hide, in the Show Sheet section: - check Conditional - Enter "vShowSheet" for the Condition (without the quotes).
3. If you are using V9+, assign Action to the button: Action: Set Variable Variable: vShowSheet Value: =(vShowSheet-1)*-1
That Value expression will toggle the variable value between 0 and 1.
3 If you are using V8, define a macro like this: Sub ToggleShow ActiveDocument.GetVariable("vShowSheet").SetContent ActiveDocument.Evaluate("(vShowSheet-1)*-1"), true End Sub
how can i make , not having connections between one sheet to another sheet. Here in two sheets i am using same objects and expressions. If i am changing any positions or values of particular object, it should not get effected with another sheet.
First Sheet is "G1" contains slider and barchart based on slider movements the barchart changes.
Second Sheet is "G2" contains the same objects , slider and barchart based on slider movements the barchart changes.
Now my requirement is when i am working with "G1" and making changes that should not be effect to "G2". Totally i don't want any relationship between this two sheets.
