Hiding Named Range based on validation selection on another WS

Hi there,

I've got a worksheet ("Main") that has a validation box that the user selects an option from (Range: H12:J13). the possible options are Red Red,Blue Blue, Colour Group, Rough Rough, Smooth Smooth, Texture Group.
on sheets(1) i have a list of named ranges. they are: RedRed, BlueBlue, ColourGroup, RoughRough, SmoothSmooth, TextureGroup.

The named ranges (eg RedRed) names are derived from the cell value of the first Row in column A of that bordered range. (note that the namedrange.name has no space whereas the validation selection does)

When the user selects an option (say RedRed) from sheet ' main' then all the named ranges except for RedRed should be hidden. Similarly for (BlueBlue, RoughRough, SmoothSmooth)

ColourGroup and TextureGroup on the other hand do not relate to a named range. They are values that are found in 2nd row below named ranges - common to more than one named range (in Col A row 2 of RedRed cell.value = ColourGroup & in Col A row 2 of BlueBlue cell.value = ColourGroup). When the user selects this option (Eg ColourGroup) then the RoughRough & SmoothSmooth named ranges should be hidden - whereas all the 'colours' are visible on sheets(1)

I've attached a sample WB

Try it. I was a little changed the existing codes.

thank you nilem, I should be able to modify this to suit my file!

Is there any way we can have the validation selections so that they have a space between the names like in my attached workbook?

regards

I do not understand. Are there no spaces in the validation list in my file?

Nilem, Thank you for your help

I got this working (Partly)

there are a couple things that I need some more help with

* From the validation box *
1. Do not show any numbers as a selection
2. When the user selects the 'Group Options' then the WS Crashes

I've attached A sample WB which contains the code you posted above with the data from my problem
Regards

Hi
Open your file "example8", press Ctrl+F3 and see a list of names. I added a button "Clear Names" to get rid of unnecessary names. This will avoid errors.

Excellent Nilem! Thank You for your help with this!!

Also how could i get this to unhide named ranges over multiple worksheets?

The name format of the worksheets i want this to run on are always of ##-##-#### date format

The issue is that the named ranges would be the same over each WS.

i.e. I would receieve an error as we cannot have more than 1 named range with the identical name i.e. on sheet(1) nm = John_Smith and on sheet(2) nm = John_Smith also.

The code i have been using to automatically name the ranges is

Please Login or Register  to view this content.

Jordan, why do you need named ranges? It may be better just to find and hide required rows on the sheets according to type of the selected item in the list?

The number of rows in the worksheets changes from week to week. Including the number of rows within each of the named ranges.
This is why i am using named ranges

regards