VBA to display scenarios based on Combo Box Selection

[judasdac]

Just looking for another set of eyes to take a look at this worksheet and macro for me. I just want to create a combo box that will allow my manager --- not so good at using menu commands or the scenario manager --- to choose one of five different budget scenarios. I can't seem to get the actual scenarios to change when the selection is made from the combo-box.

This is the code:

Sub ChangeScenario()
' Changes the scenario on the worksheet according to the choice made
' in the drop-down list.
activesheet.Scenarios(Range(ActiveSheet.Shapes("DropDown").ControlFormat.
LinkedCell).Value).Show
End Sub

I've attached the worksheet. Any help would be tremendously appreciated since I've been struggling with this a bit since I thought I had a working macro.

Cheers!