Empty Print(preview)

G

Guest

I have made a macro that reorganizes a big table into a series of small
tables. Based on these 20-30 tables I then make graphs, which are moved into
a seperate sheet which I then use as a basis for my report, adding comments
etc.

If I print this sheet where I moved the graph I print all the normal text
with the rigth format and all. But all graphs, textboxes and pictures are not
printed. Also the preview shows no graphs etc. Just empty pages with only the
text I added.

If I copy a few of the graphs by hand to a new worksheet I can print them.
If I select only a single graph I can print it as well.

Just my report cannot be printed. Who knows what I did wrong?
 
T

Tushar Mehta

Sure speculation...

Check Tools | Options... | View tab | Objects section. 'Show all'
should be selected.

Also, double-click each chart, then the Properties tab. Is 'Print
object' selected?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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