I need a macro that leaves sheets 1-3 visible at all times, but will hide sheets 4 - 20 and show them only when the value of B1 in wksht. 1 equals the name of a given sheet. I've seen a few macros similar to this, some on this site, but I don't seem to be able to modify anything I've found to achieve this result. I'm a newb with VBA so I realize that doesn't help.