Showing / hiding sheets

[oxiofrt]

Hi,

I would like to be able to use buttons to show / hide sheets.
Is it possible ? I have only found : ActiveDocument.Sheets("Feuille 2").activate

Thanks a lot for your help.

[Anonymous]

Same as showing/hiding objects - use a variable as a condition to hide/show, and toggle the value of the variable with a button.

[#3]

Have the macro attached to the button toggle the value of a variable (if 0 set to 1 else set to 0) and then condition the 'show' of the sheet depending on the value of the variable.

Hope this helps.

Gordon

[oxiofrt]

ok for the macro but how to "condition the 'show' of the sheet" ?

[#5 · Accepted solution]

Sheet Properties>Show sheet