Can you post up the Workbook with sample data of some sort.

the issue could be one of anything. It sounds like you have some sort of onchange event firing off.

You can also probably simplify some code by looping all the sheets as well to hide or unhide what you need vs selecting each one individually.