Hide Sheets Issue

[#1]

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

[shumailh]

Hi sunil,

I was also looking for the same query.

Regards,

[#3]

i can't decypher your macro code

could you please send a correctly indented version ?

[prieper]

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

[#5]

I have already done 'Show condition', it is able to hide, but not able to show the sheet on selection.

[prieper]

Hi,
try something like the attached

HTH
Peter