Howdy,

I have a need for a macro to show or hide certain worksheets.

I have an input page where I will specify one of 6 different types of tests. Once I specify a test I want only the page containing that tests charts to show and the other chart pages to hide so that others do not accidentally print out the wrong chart.

To further explain, I have tests a,b,c,d,e,f and right now I have charts A,B,C,D,E,F all on separate pages.
I have a test setup page where I say what test I am running and input a-f.
Assume I want to run test c, after I input test c I want only chart C's worksheet to show and the others to be hidden.

Thanks again for the help.