Hi all,

I've been programming in VBA for couples of month now, but I'm still coming accross many obstacles I need to help with. If any of you would help me with this one, I would be very grateful!

I would need to update several charts on one of the Excel sheets whenever the user activates the sheet.

In such a cases when I needed to update sheets automatically after clicking, I used this code:

Please Login or Register  to view this content.
However, it seems not to be applicable to this case, because there are several "activate" commands through out the code. So, it appears to be looping.


Please Login or Register  to view this content.
Thank you very much for any help!