Right click the txt box; select fro popup menu "Format Shape"
In left hand panel; select "Properties"
In lower half of dialog, uncheck "Print Object"
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"AndrewR" wrote in message
...
In XL2003 I could put a text box on a chart and mark it to NOT print with
the
chart. Having upgraded to XL2007 I can't find how to do that and previous
(2003) spreadsheets that had non-printable text boxes now print those
boxes
in XL2007.
Can anyone help, please?
--
Andrew