Conditional sheet hide / show macro

**NJDevil** · 08-28-2012, 08:13 PM

I'm trying to figure out a way to use tabular info to conditional show or hide worksheets. Say we have:

Column H contains the worksheet name which is to be hidden / visible

Column J contabs "Tab" if the contents of column H is a worksheet. It could be a different type of document. If it is not "Tab" then leave it alone.

Column M contains "X" if it should be left inact (visible) or is blank if the worksheet names in colum H shoudl be hidden (assuming it is a worksheet based on column J = "Tab")

This is all set up in a table.

I want loop through the table and only show (make visible) those worksheets that are defined in the rows that have "Tab" in Col J and "X" in Col M.

I've tried for hours but cannot get this to work.

Can someone please help?

Many many thanks in advance for yoour help!

NJDevil

**xLJer** · 08-29-2012, 02:03 AM

I worked this code out in Excel 2003. Maybe it will help
with your solution to hiding or showing worksheets based
on two conditions. Try it out in the attached file.

Please Login or Register  to view this content.

**NJDevil** · 09-23-2012, 04:25 PM

Sorry for the long delay in my response. I have been super super busy!

I used your method, tweaked it a bit, and it works great!

Thank you so much and, again, sorry for the long delay.

NJDevil