PC Review


Reply
Thread Tools Rate Thread

Another odd VBA glitch in 2007

 
 
teepee
Guest
Posts: n/a
 
      31st Mar 2007
With the following code 2007 will change the colours but won't change the
border lines
In fact it takes out all the border lines that were already there.
Anyone know a workaround?

ActiveChart.SeriesCollection(2).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
With Selection.Interior
.ColorIndex = 38
.Pattern = xlSolid


 
Reply With Quote
 
 
 
 
=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a
 
      1st Apr 2007
No workaround to offer, but we can give all of these a name?
YACAGG: Yet Another Carting and Graphic Glitch ??

They seem to be piling up.

"teepee" wrote:

> With the following code 2007 will change the colours but won't change the
> border lines
> In fact it takes out all the border lines that were already there.
> Anyone know a workaround?
>
> ActiveChart.SeriesCollection(2).Select
> With Selection.Border
> .Weight = xlThin
> .LineStyle = xlAutomatic
> End With
> Selection.Shadow = False
> With Selection.Interior
> .ColorIndex = 38
> .Pattern = xlSolid
>
>
>

 
Reply With Quote
 
teepee
Guest
Posts: n/a
 
      1st Apr 2007

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis)> wrote in message
newsF7120C9-9BF9-4925-B412-(E-Mail Removed)...
No workaround to offer, but we can give all of these a name?
YACAGG: Yet Another Carting and Graphic Glitch ??

They seem to be piling up.

Oh well I expect they'll fix them as they get round to it


 
Reply With Quote
 
=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a
 
      1st Apr 2007
I understand they're collecting these little jewels and that SP1 is already
in the works - but I would not expect to see it until late this year?

"teepee" wrote:

>
> "JLatham" <HelpFrom @ Jlathamsite.com.(removethis)> wrote in message
> newsF7120C9-9BF9-4925-B412-(E-Mail Removed)...
> No workaround to offer, but we can give all of these a name?
> YACAGG: Yet Another Carting and Graphic Glitch ??
>
> They seem to be piling up.
>
> Oh well I expect they'll fix them as they get round to it
>
>
>

 
Reply With Quote
 
teepee
Guest
Posts: n/a
 
      1st Apr 2007
I wish they'd fix the VBA password facilty so it wasn't so easy to crack.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2007 glitch JohnR Microsoft Outlook Discussion 1 20th Nov 2008 09:02 PM
Anoying Excel 2007 glitch teepee Microsoft Excel Discussion 0 3rd Apr 2007 12:03 AM
Anoying Excel 2007 glitch teepee Microsoft Excel Misc 0 3rd Apr 2007 12:03 AM
Another odd VBA glitch in 2007 teepee Microsoft Excel Discussion 4 1st Apr 2007 09:16 PM
Another odd VBA glitch in 2007 teepee Microsoft Excel Misc 4 1st Apr 2007 09:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:23 AM.