unwanted grey border on picture copied from XL

K

Keith R

ok, I didn't get a response in the XL newsgroup, so hopefully someone here
can help;

I am using VBA (Office97) to copy (copyaspicture) ranges from Excel and
paste into powerpoint slides.

To hide the Excel gridlines, I made the cell fillcolor white for an area
larger than the range(s) I copy

however, every image that is pasted into PP has a thin grey line/border on
the left and top of the image. I'd really like to get rid of those lines
because they distract from the rest of the information.

At the moment, my only option seems to be to manually place a white
rectangle over both borders, which means hand-editing ever slide...which is
a lot of extra non-value added work.

Has anyone ever run into this before? My guess is that it is related to how
Excel copies as a picture, but does anyone have a workaround to get rid of
it?

TIA,
Keith
 
S

Steve Rindsberg

Wouldn't something like this work (ie, turn off the grids in Excel prior to
copying the content):

ActiveWindow.DisplayGridlines = False

--
Posted to news://msnews.microsoft.com
Steve Rindsberg, PPT MVP
PowerPoint FAQ - www.pptfaq.com
PPTools - www.pptools.com
===============================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted borders on imported pictures 4
Unwanted border with other texture and picture 4
Probably not possible, but... (XL -> PP, and gray border on pictures with VBA) 1
PP2003: autoshapes have an unwanted shadow 2
border around slide 2
Word Word 2010 - White Space Round Images 8
Add Photo Album: Eliminating the Border? 7
How do I get rid of the white border on a printed copy of a ppt p. 1

Top