Printing Objects

S

soldier1981

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J
 
D

Dave Peterson

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.
 
S

soldier1981

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J
 
D

Dave Peterson

The menu option for autoshapes says: Format Autoshape

Did it work when you tried it?
 
S

soldier1981

Okay, I'm an idiot. I was a little premature when I said it worked. I
should have said I found the spot where I can print the object, but I need it
printed BELOW the cells on the sheet. Whenever I print, it comes on top of
the sheet & blocks out the words under it. Can you still help with this??
Thanks. ~J
 
D

Dave Peterson

When I've printed objects like this, it always appears where I put it. So I
think you'll have to put it at the bottom -- or put another one at the bottom,
but only print that one.
Okay, I'm an idiot. I was a little premature when I said it worked. I
should have said I found the spot where I can print the object, but I need it
printed BELOW the cells on the sheet. Whenever I print, it comes on top of
the sheet & blocks out the words under it. Can you still help with this??
Thanks. ~J
 
Top