Unwanted graphic (?) appearing on spreadsheet

G

Guest

I've created a spreadsheet which is really a design of a electronic relay.
When I print the spreadsheet a very short green line is printed on the border
of an empty cell in two separate places on the spreadsheet. I have
highlighted the area around the lines and cleared all cell contents, cleared
all border and patterns under the Format-Cell options. I have deleted the
rows encompassing where the lines appear and the lines remain in the
undeleted portions. I have even blown the spreadsheet up to 400% but nothing
appears and I've passed the cursor slowly over the area to see if the cursor
changes shape, possibly indicating there is part of a graphic present -
nothing. I have even copied the spreadsheet to a new sheet to see if I could
lose the two green lines but nothing has worked.

Does anybody know of a way I can purge these lines from appearing?
 
D

Dave Peterson

Just guesses...

You could have a macro that fires when you print (or print preview). It could
be either adding that line (or shape) or just making it visible.

If you start excel in Safe mode:
close excel
windows start button|run
excel /safe

Then file|open your workbook, then do your print, do you get the same
line/shape?

If yes, then it wasn't a macro.

If no, then maybe it was.

Can you get to the project and inspect the code?

=======
And just more guessing--does this happen with all your printers or just one? If
it only happens with one, maybe it's the printer (or printer driver???).
 
D

Dave Peterson

Sometimes you can resize a picture/button so flat that it looks like a line,
too.
 
G

Guest

Hi Dave,

Yes, I've seen that myself but I don't think that's what happened in this
case. I exploded the spreadsheet up to 400% and could not get my cursor to
change to crosshairs when passing it over the spot where the lines appear in
a printout.

As I mentioned though, I'll look at the code when I have a chance and see if
it shows me anything....bye
 

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

Top