View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default How do I prevent a text box from printing in XL2007?

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