Minggu, 11 September 2011

[ExcelVBA] Re: Error and shutdown

 

David,

This may also be useful http://peltiertech.com/Excel/Charts/FixFonts.html
it does appear to me that if breaking this into multiple workbooks is not an options that programmatically disabling font autoscaling for the current charts and then altering the default autoscaling behaviour in the registry would fix the issue.

Jason

--- In ExcelVBA@yahoogroups.com, "David Braithwaite" <dbraithwaite@...> wrote:
>
> David
>
> What keeps you from breaking this into multiple workbooks to get around problem?
>
> I was thinking that if it were smooth “presentation” of the data,
>
> Using a “pile” of workbooks could be (at least partially) hidden by using hyperlinks to instrument the navigation.
>
>
>
> Db
>
>
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of David Lanman
> Sent: Sunday, September 11, 2011 10:39 AM
> To: ExcelVBA@yahoogroups.com
> Subject: Re: [ExcelVBA] Re: Error and shutdown
>
>
>
>
>
> Thanks David. Charting and trying to do it with VBA is not very good. The order you do it in makes a difference and almost anything you do to the worksheet seems to make a difference.
>
> With ActiveChart.Parent
> .Placement = xlFreeFloating
> End With
>
> The above seems to help some, but does not seem to “stay in place.”
> Selection.TickLabels.AutoScaleFont = True
> Will void the previous VBA and seems to be the norm when you record a macro. MSN help documentation is pretty poor too.
>
> David
>
> From: david braithwaite <dbraithwaite@... <mailto:dbraithwaite%40charter.net> >
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
> Sent: Saturday, September 10, 2011 7:48 PM
> Subject: Re: [ExcelVBA] Re: Error and shutdown
>
>
> Hi david
>
> It appears that there is a maximum of 512 font types in an excel workbook.
>
> Microsoft posted this
>
> http://support.microsoft.com/kb/215573
>
> The article indicates that the number often grows out of control due to
> auto-sizing ---
>
> I have found that if you google the error message you often come up with
> something useful.
>
> Do this and you will find that other people have been where you are.
>
> Db
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar