using vba macro to change all charts at same time

[tessawanders]

Hi Everyone,

I have about 60 charts in my active worksheet that I would like to change the size and font of.
I already wrote the code to run it on one, but I would like a piece of code that runs it automatically on al the charts in the active worksheet. How should I adjust the code?

Please Login or Register  to view this content.

Thanks a million!!

Crosspost: http://www.mrexcel.com/forum/excel-q...eet-macro.html

[oeldere]

Crosspost

http://www.mrexcel.com/forum/excel-q...eet-macro.html

[tessawanders]

Im new to these websites? What about it being a "crosspost"?

[oeldere]

See this link for crossposting


http://www.excelguru.ca/content.php?184

[tessawanders]

Sorry about that, I didnt know. Hope someone can still help me!!

[tessawanders]

Thanks for the advice. I received an answer on mrexcel.

[oeldere]

For the members who follow this threat.

And the code below is the given answer on mrexcel.

Please Login or Register  to view this content.