Add a change event to change charts from different sheet

[erickguz]

I downloaded vba code that changes the y axis on my graphs from spreadsheet guru. It's great for my forex charts, etc.

They provide code for a worksheet change event that allows the charts to change once a cell is changed.

I right clicked on each tab and then under "view code", entered the following code as worksheet_change event. Works great.

Is there a way to update all charts, on the many different sheets, from just one cell on the first sheet1? I've tried but have been unable to figure it out.

Following is the code:

Private Sub Worksheet_Change(ByVal Target As Range)
'PURPOSE: Run AdjustVerticalAxis macro when Cell C2 is changed

If Target = Range("C2") Then Call AdjustVerticalAxis

End Sub


Again, it updates the chart after I change data in cell C2 for each sheet. I would like to have the charts updated on all sheets without me having to either enter data into each sheet. By default, the original macro updates all charts on one sheet after you left click on any chart on that sheet.

Thanks.
Erick