hide columns if a cell has a specific word

this works with option buttons

Please Login or Register  to view this content.

i would use this code for every map.

however, i dont know how to transfer this to a cell value (text) in a specific cell

ive had a try but i cant get it to work.

this is the code ive done (not sure how far off i am):

Please Login or Register  to view this content.

i think youve misunderstood me.

i dont want to use option buttons.
i want to use text from a drop down box in cell ER11.

sure.

in my drop down box i have the options: Apple; Banana; and Orange because I have 3 maps (Apple; Banana; and Orange).
The dropdown box is in cell D1

The Apple Map stretches from column F to I
The Banana Map stretches from column K to N
The Orange Map stretches from column Q to T

hope that helps. thanks

theres an error. it says:

Compile error:
Ambiguous name detected: Worksheet_SelectionChange

it highlights this: Private Sub Worksheet_SelectionChange(ByVal Target As Range