 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007Another odd VBA glitch in 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 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. > With the following code 2007 will change the colours but won't change the > border lines [quoted text clipped - 10 lines] > .ColorIndex = 38 > .Pattern = xlSolid 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 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? > 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 I wish they'd fix the VBA password facilty so it wasn't so easy to crack.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.