Chart displayed is selected via a dropdown menu

I have a workbook with several sheets of data and charts... I want to be able to hide all of the data sheets and individual charts so that when someone opens the workbook they only see a single sheet. I want the individual that opens the workbook to select from a dropdown menu and *poof* that chart is displated on the "front page".... I am pretty proficient with Excel, but not with VBA or the use of Macros. I found the below code, which appears todo want I want.... But it doesn't work. Is there something that I need todo in order for the code to "run"? I need to be able to send these files to others and have it work without them doing anything "special"....

The code I found...

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim chartToCopy As ChartObject
'launch macro when InCell dropdown in E3 changes
   If Target.Address = Range("e3").Address Then
'delete existing chart
       If Me.ChartObjects.Count > 0 Then
           Me.ChartObjects(1).Delete
       End If
       If Target = "Branch1" Then
           Set chartToCopy = Sheets("Sheet1").ChartObjects(1)
       ElseIf Target = "Branch2" Then
           Set chartToCopy = Sheets("Sheet2").ChartObjects(1)
       Else
           End
       End If
       chartToCopy.Copy
       Me.Paste Range("c5")
       Application.CutCopyMode = False
   End If
End Sub

Thanks!
Buster

Buster, please read the Forum Rules and use Code Tags in future. I will add them for you this time.

Have you amended the code to work with your sheet & chart names?

Your error is because you placed the worksheet code in a standard module. I'll take a look at it later

I've moved the code & changed it slightly

Originally Posted by royUK

I've moved the code & changed it slightly

royUK,

It works! So what did I do wrong as I build the code into the sheet/combo chart that I have? You said I placed it in a standard module, I just used the insert module from the editor, what do I need to do?

Thanks for the help!

Buster

EDIT
--------------------------------------------
I figured it out!! I needed to view the code for the sheet and then add the VBA there.....

This is pretty powerful stuff!!! I need to figure out how todo more of this in Excel.

Again, thanks for the help!