Conditionally Display/Hide Workbook Tab/s

[SteveGilbert]

I'm relatively new to VBA and have a 2010 Excel Workbook that has several tabs that I want to display/hide based on 'Y', 'N' values that would be entered in cells within Sheet1. For instance if the value in B1 is 'Y' I want Sheet2 to be visible, and if the value is 'N' Sheet2 should hide. The same will be true for Cell B2. If the value is 'Y' display Sheet3 and if the value is 'N' hide it.

Please can you offer some guidance how to do this.

Many thanks, Steve

[coreytroy]

ALT + F11 to access VBA
Paste code into Sheet1

Please Login or Register  to view this content.

[SteveGilbert]

Corytroy, Thank you for your assistance. Really appreciate that. Perfect.

Best wishes,
Steve