Possible to make blocks of cells hide/unhide with a drop down menu or radio buttons

Hello.

Please see the attached file.

I have maps of an area. There are going to be approx 7 of them varying in colour, shape, text and figures.
(there are 3 in my attached example)

I was hoping (if possible) to only show one map at a time.
So if i want to view the "zones incidents" map i can click "zones incidents" in a drop down menu or radio button and it will appear.

thanks

Hello
Not sure if you were looking to do this with VBA but it could be done using Conditional Formatting. See attached example. It hides the non-selected ranges by formatting them to match the background colour.

Hope this helps.
DBY

thanks for the effort.

the reason behind my idea is so there is no need to scroll to view a new map. with your solution, the maps are still located in different areas which require you to scroll to view them.

is it not possible to have them in the same position as you select each one?
thanks

thanks!!
that works great

im currently at work so i cant test this on my mac.
does it involve activex. if it does then it wont work on a mac

If you only need to see the map and VBA is not an option on your mac, then perhaps you could use a picture lookup. With your maps on one sheet and named as a reference. See new attachment.

DBY

thats great!!
can you please explain to me how you do that DBY

Unfortunately my solution uses ActiveX option buttons and I didn't realize that wouldn't work on a Mac. I have no experience using Office on a Mac.

Each of your Maps are created as Named Ranges. I then created another named range in this instance I chose 'Zone' which uses the Indirect function linked to the drop-down cell with the following formula:

Please Login or Register  to view this content.

Named ranges cannot have spaces so the Substitute function replaces those with an ( _ ) underscore.

You then select and copy the one of the Maps/Range and use Paste Special to paste it as a Picture Link. Then select the picture and in the formula bar type: =Zone

DBY

"I then created another named range in this instance I chose 'Zone' which uses the Indirect function linked to the drop-down cell with the following formula:"

i dont understand this bit. where did you insert the formula?

Sorry I had to log off yesterday. You insert the formula when creating the new name from the Formulas Tab > Define Name . See attached image.

New Name.JPG

DBY