Graph formatting changing

[Ca1icoJack]

Using a macro I have imported some data and created 8 graphs on a sheet which is then printed. The printout reverts all character formatting to the default sizes.

How can I prevent it from doing this so the formatting I specify in the code is retained?

I've done this before in other macros and have never encountered this error and so am at a loss.

Thank you

 

[SkipVought]

Hi,

Where is the code that you refer to? My crystal ball is a bit foggy today.

You might also set the

ActiveSheet.chartobject2(1).Chart.[b]ChartArea.AutoScaleFont = False[/b]

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

Immediately before the line of code to print.

The formats are all correctly displayed on the screen, if I print manually they are also correct. However, if the code prints automatically they are all reset.