Macro to Modify Worksheet_SelectionChange

**jordan2322** · 01-09-2012, 06:40 PM

Hi Guys,

I need a macro that puts this onto the worksheet:

 Worksheet_SelectionChange(ByVal Target As Range)

    If Not Application.Intersect(Target, Range(****See Note 1***)) Is Nothing Then
    hide/or show other named ranges below named range above 
    End If

Note 1 - Named range
Note 2 - I want to be able to stipulate which named ranges will show/ hide.

one way i thought i could achieve this is by listing all the named ranges in order - then by having a 1 or 0 column next to these ranges to identify what is to be shown/ hidden.

Im open to suggestions on other ways about achieving this

regards

**davesexcel** · 01-09-2012, 07:23 PM

What are you trying to do?

**jordan2322** · 01-09-2012, 07:30 PM

Ive reworded the question and uploaded an example file - please see
regards

**jordan2322** · 01-09-2012, 10:44 PM

.....bump

**royUK** · 01-10-2012, 02:22 AM

You've not really answered the question - why do you need to do this?

What is the purpose of the code, from what I can see you would be better using Custom Views

**jordan2322** · 01-10-2012, 05:57 AM

The workbook this code will be used in is a report viewer. output files from an external program are copied and pasted into newly created worksheets in this workbook. All of the copied data is in named ranges. I want to have a macro run that will insert this code in so that the users of this report viewer workbook are easily able to toggle the view in the report. By toggle view I mean toggle the named ranges.

Hope this helps