Print charts in a 30 tab workbook

B

bmac

I have 32 tabs in a workbook, whereby each tab has a chart and data on it.

I created a Menu tab with options to choose what worksheet I want to print
The problem is that when the worksheet is printed the chart is greyed out.
When I goto the worksheet the chart is greyed out unless I click on it. I
want the chart and data to print.

Is there a limit to how many macros can be created? Size of my excel is
430KB, could this be the issue?
 
J

Jon Peltier

Go to Tools menu > Options > View tab. Under Objects, select Show All. This
will make your charts visible.

- Jon
 

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