Empty Print(preview)

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top