Remove Chart Area Border - Where in Code is it Added?

I have very little knowledge of editing Visual Basic and I'm a little stuck on something: somewhere within this code (below) I am getting a chart area border showing on my graphs - but I don't want a border and cant find the coding to remove it. (I previously had Excel 03 and found this easier as I would record a macro and look at the coding to see where I needed to edit, but I can't seem to do that in 07


Could someone point out how I could remove the border please (do I need to attach a sample workbook for this?)

Many thanks in advance.

Please Login or Register  to view this content.

Hi Janc,

If you can attach me a sample file, I can set it right for you

Regards,
Abi

If you can remove it manually, record a macro while you do it. Then find the equivalent code in your macro and modify it.

Regards

Hi,
The border is applied by default, so you may not see the code.

To remove the border try:

Please Login or Register  to view this content.

Jbentley, thank you so much, that works perfectly!

Just as an aside, you can make your code much shorter, more efficient and quicker by:

* removing all the default settings for fonts, etc
* using With ... End With instead of xxx.Select ... Selection ...
* enclosing your code in ... ScreenUpdating=False / ScreenUpdating = True

I have adjusted some, but not all, of your code in the attached, updated, workbook.

Regards

You're welcome. Thanks for the rep.

I learn as much from doing this as others benefit from it so it's a mutual gain.

Regards