Displaying Scenarios

  • Thread starter Thread starter Jeffrey Albaum
  • Start date Start date
J

Jeffrey Albaum

I have set up a number of scenarios on a worksheet as they
relate to different versions of my budget. Rather than
having to go in everytime and display each one
individuall, I would like to enter a parameter in one cell
that will automatically display the right scenarios.
Hopefully, using a conditional statement of some kind.
Any help would be greatly appreciated.

Jeffrey Albaum
Controller
Jet Moulding Compounds Inc.
Ajax, Ontario, Canada
 
How about a worksheet_change event?

I created a couple of custom views and then rightclicked on the worksheet tab
that held the important cell. (I chose A1).

Then I pasted this in:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub

On Error Resume Next
ThisWorkbook.CustomViews(Target.Value).Show

End Sub
 
Back
Top