Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Boxes Do Not Print In Excel
We have several excel 2003 files that have text boxes placed on a chart.
These text boxes used to print with the chart. A few users upgraded to Office 2007. They open the file with the chart and text boxes and they are able to print and see all text boxes on the printed page. The file was not converted to a 2007 format it was just opened with 2007 in compatibility mode. Now when the Excel 2003 users open the file and print the text boxes do not appear. I have found that if you have Excel 2003 you can highlight all of the boxes and go to format Text box and then set each box to "Print Object" There are hundreds of these in hundreds of sheets so manually doing this on each is not a very viable option. Is there a way to mark every text box in a workbook to print? Or is there a way to prevent this from occuring when a user opens the file in Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text boxes in Excel 2003 chart won't print | Charts and Charting in Excel | |||
Text boxes Excel 2003 change position in print preview | Charts and Charting in Excel | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
Why do the ActiveX text boxes move when I print preview? | Excel Worksheet Functions | |||
print text boxes | Charts and Charting in Excel |