I am trying to write a marco that would mimick the "if then" statement in
excel. I have a workbook with several tabs, but depending on the info
entered into the first tab only some of the proceeding sheets are populated
(which is triggered from info placed in the first sheet). I want to create a
button that can be clicked if the suer chooses, that will hide any non-needed
sheets based on what the user enters into the first sheet, but I am clueless
as how to write this in macro form. Any ideas???

Thanks! Bits of Colour