How to hide a Sheet without conditional show

[#1]

Hi,

I want to hide a sheet by wrting a macro.Please help me if anyboady implemented the solution for the same.

I created a button called as XXXX and once i qlik on this button,need to hide "YYYY" sheet.

thanks in advance.

Ram

[blaise]

Set a conditional show on the Sheet if a variable is set to 1, f.ex. if($(varSheetShow)=1,1,0)

Write a macro that sets the variable varSheetShow to 1.

[#3]

Yes i already tried this.In this case how can paas the value to the conditional show.

[#4]

Yes i already tried this.In this case how can paas the value to the conditional show.

[#5]

I mean into $(varSheetShow)= through macro.Can u paste the sample script if you have

[blaise]

Sub dimShow

set var = ActiveDocument.Variables("dimShow")

var.SetContent 1,true

end sub