Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print charts in a 30 tab workbook
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? -- bmac |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print charts in a 30 tab workbook
Go to Tools menu Options View tab. Under Objects, select Show All. This
will make your charts visible. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "bmac" wrote in message ... 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? -- bmac |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print charts in a 30 tab workbook
such a simple answer to my question. thank you so much
-- bmac "Jon Peltier" wrote: Go to Tools menu Options View tab. Under Objects, select Show All. This will make your charts visible. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "bmac" wrote in message ... 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? -- bmac |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print charts in a 30 tab workbook
Everything's simple, when you know how.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "bmac" wrote in message ... such a simple answer to my question. thank you so much -- bmac "Jon Peltier" wrote: Go to Tools menu Options View tab. Under Objects, select Show All. This will make your charts visible. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "bmac" wrote in message ... 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 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? -- bmac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Need to print a workbook but worksheets have diff print areas | Excel Discussion (Misc queries) | |||
How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Copying charts from workbook to workbook | Charts and Charting in Excel |