Automation Error

I have Access-to-Excel automation trying to use 7 (seven) Worksheets.
One worksheet ("DataSheet") receives the data from Access, & the other
6 are required to display 15 Charts each.

All was fine w/ the using "DataSheet" & 5 Chart Worksheets, but adding the
6th Chart Worksheet & pasting in Charts which will have Cell References
modified gives this...

"No more new fonts may be applied in this Workbook".

Apparently if I keep clicking each "instance" of this message, the Chart then
is pasted & "appears" to be Working properly.

Any insight welcomed.

TIA - Bob

Search support.microsoft.com for the error message. One of the several
suggested links will be http://support.microsoft.com/default.aspx?
scid=kb;en-us;215573

It really comes down to turning off the 'autoscale fonts' feature.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I have Access-to-Excel automation trying to use 7 (seven) Worksheets.
> One worksheet ("DataSheet") receives the data from Access, & the other
> 6 are required to display 15 Charts each.
>
> All was fine w/ the using "DataSheet" & 5 Chart Worksheets, but adding the
> 6th Chart Worksheet & pasting in Charts which will have Cell References
> modified gives this...
>
> "No more new fonts may be applied in this Workbook".
>
> Apparently if I keep clicking each "instance" of this message, the Chart then
> is pasted & "appears" to be Working properly.
>
> Any insight welcomed.
>
> TIA - Bob
>

Tushar - Thank you. I thought it was probably a setting.

Bob

"Tushar Mehta" wrote:

> Search support.microsoft.com for the error message. One of the several
> suggested links will be http://support.microsoft.com/default.aspx?
> scid=kb;en-us;215573
>
> It really comes down to turning off the 'autoscale fonts' feature.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > I have Access-to-Excel automation trying to use 7 (seven) Worksheets.
> > One worksheet ("DataSheet") receives the data from Access, & the other
> > 6 are required to display 15 Charts each.
> >
> > All was fine w/ the using "DataSheet" & 5 Chart Worksheets, but adding the
> > 6th Chart Worksheet & pasting in Charts which will have Cell References
> > modified gives this...
> >
> > "No more new fonts may be applied in this Workbook".
> >
> > Apparently if I keep clicking each "instance" of this message, the Chart then
> > is pasted & "appears" to be Working properly.
> >
> > Any insight welcomed.
> >
> > TIA - Bob
> >
>

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> Tushar - Thank you. I thought it was probably a setting.
>
> Bob