Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Dynamic hide/unhide sheets based on cell value

Let say that my workbook have sheets as follow: "Workbook content"; "1"; "2"; "3"; "4"; "5"; "6"; ...etc...

Column "A" in sheet named "Workbook content" is a list of sheets from workbook and it looks like: A1="1"; A2="2"; A3="3"; A4="4"; A5="5"; ...etc...

Now, I want to be able to dynamic hide or unhide sheets based on value In column "B" (or any other column on this "Workbook content" sheet). For example, if B1="Hide"; B2="Hide"; B3="Show"; B4="Hide"; B5="Show"; B6="Show" then sheets with name "1", "2", "4" should be hidden and other sheets ("3", "5" and "6") should be visible on sheet tabs. As I say, if is possible, system should be dynamic. How can I do this? I would be very grateful if someone can help me.