loop system for hiding and unhidding worksheets

Hi There,

I am new to excel VBA programming and i require some help.

I have created a list as shown below, and what i need it to do is; when i choose something from that list to activate i.e. to hide or unhide the linked sheet/tab. what i have already is the following.

List of inputs:

-ILSS
-Tensile
-Compression
-IPS
-Bearing Strength
-FWT
-Impact
-G1c
-Lap Shear
-Floating Roller Peel
-Climbing Drum Peel
-Density
-Burn Off
-Acid Digestion
-Corner bend
-G2C
-DMA


and the program i have currently is:

Please Login or Register  to view this content.

The problem i have with this, is that i have to copy and paste the above program for each input on the list of inputs and my main question is, how can i do it in a loop so i dont have to copy and paste it for all different inputs. i.e. set the input to true and all else false so it only returns the worksheet i want and hides all the others.

Many thanks in advance if you will be able to shine some light at this end of the tunnel for me. Apologies if i am not making much sense, please mail me if you think you can help and dont fully understand my question.

Is your code hiding every sheet except for the one chosen from the list or are there other sheets that will remain visible?

Hi Mordred

yes only the chosen and all others to hide.

But i have other worksheets that are not included within this code nor will be included but they have to be available and not hidden.