Chart event on axis scale change

I've got a worksheet with five embedded XY-scatter plots. The first one is the "main" chart and I've got a macro that copies the y-axis scale settings of the first one onto the other four. Right now the macro is triggered via a button, but I was wondering if there is a way to trigger it via a chart event. Specifically, I was wondering if there is a way to run the macro whenever a change is made to the scale of the y-axis in the first chart. From what I can tell, all chart events with the exception of 'Calculate' are triggered before any changes occur, and the 'Calculate' event isn't much use since it's only triggered when the series data changes.

Does anyone have any suggestions of a workaround or are we stuck with using the button?

Thanks!

dflak, I'm not sure I understand; what macro are you referring to? if something triggered that "change cell" macro, then why couldn't I simply use that trigger to call my "update chart" macro? That's exactly my problem.

Andy Pope's suggestion of activating the macro (with the appropriate axis change checks) after something else is selected is something I've thought about, but I'm kind of concerned of the potential for the users to do something truly bizarre which would either not trigger that event or even cause a crash. I really hate that particular breed of "Hey! I found a new bug" conversations.

I guess the command button is still (relatively speaking) the most fool-proof way of doing this after all.

Many thanks guys!