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?