Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have written below macro code to hide sheets, however it is only hiding sheets but not showing it.
Code
sub
showObjectA
set
p=ActiveDocument.Variables("pShowObject")
true
end
sub
sub
showObjectB
set
p=ActiveDocument.Variables("pShowObject")
true
end
sub
sub
showObjectC
set
p=ActiveDocument.Variables("pShowObject")
true
end
sub
/Code
Please let me know wht I need to add it in the code to show the sheets as well.
Thanks,
Sunil
Hi sunil,
I was also looking for the same query.
Regards,
i can't decypher your macro code
could you please send a correctly indented version ?
Find it in most cases more useful to link the "Show"-functionality (Object or Sheet) to a variable and then change the setting of the variable (by inputbox, macro, user-access etc).
HTH
Peter
I have already done 'Show condition', it is able to hide, but not able to show the sheet on selection.
Hi,
try something like the attached
HTH
Peter