VBA to Hide/Unhide sheets based on cell value

[SnapwireMan]

I have a workbook which has roughly 50 sheets. What I'm trying to do is automatically hide/unhide sheets based on the cell values in the first sheet. So in sheet1 cell A1 i would a value of FALSE which would trigger sheets1, 2, & 3 to hide, when that value changes to TRUE then those same sheets would unhide. I need to replicate that for the 10 corresponding sets of sheets, but for each grouping of sheets a different cell in sheet1 would be the trigger, cell A2 = sheets 4 - 10, cell A3 = sheets 11 - 20, etc. Any help on the VBA code would be greatly appreciated. Thanks everyone!

 

[xray]

This discussion is absolutely awesome. It sounds so close to what I want to try to do. I am a total dweeb/newb to this forum. I've used excel for many years, but only got very serious and learned to use stuff like conditional formats and =IF formulae this week.

Would you indulge me in another, even simpler discussion of how I would implement this very idea?

Here's what I am trying to do:

Sheet 1 has a series of cells, say, B4 to B65, each of which can accept a value of 0 or 1. Setting B4 to 1 puts that value into cell B2 on sheet 2. Putting it into B5 puts it into cell B2 of sheet 3, and so on. As you go down the list entering 1s, each one inserts the value into a corresponding sheet.

I want to be able to go down the list on sheet 1, and enter a 1 or zero into one of those cells, B4 through B65, and have the corresponding worksheet tab appear or disappear.