Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me in making a macro to show and hide sheet objects?
Thanks in advance 😃
Hi Wilnard,
What I normaly do (maybe it's not the best of all solutions) its to use a macro like this:
sub macro1
set v = ActiveDocument.Variables("vButton1")
v.SetContent "1",true
set v = ActiveDocument.Variables("vButton2")
v.SetContent "0",true
set v = ActiveDocument.Variables("vButton3")
v.SetContent "0",true
end sub
In this example its a macro for being using on click event of the 1st button in the sheet (in this sheet I have 3 buttons). After that I put the visible option of a object with vButton1. Maybe it's not the best, but it works very well.
Cheers,
Joao
Hope the attach application helps you out.