| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I prevent a text box from printing in XL2007?
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I prevent a text box from printing in XL2007?
Bernard,
Thank you for your reply. That is certainly true when I place a text box on a worksheet but when it is on a chart the "Print Object" option is not available; not greyed out, just not there. Andrew "Bernard Liengme" wrote: 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 . |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I prevent a text box from printing in XL2007?
Is the text box 'grouped' to the chart?
If so, it is treated as part of the chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, Thank you for your reply. That is certainly true when I place a text box on a worksheet but when it is on a chart the "Print Object" option is not available; not greyed out, just not there. Andrew "Bernard Liengme" wrote: 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 . |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I prevent a text box from printing in XL2007?
Bernard,
It is not grouped to the chart. If I create a text box on a worksheet I see the "Print Object" checkbox; if I cut it and paste it to the chart that option is gone. Put it back on the sheet and it's there. It certainly appears that this functionality has been removed in going from XL2003 to XL2007. -- Andrew "Bernard Liengme" wrote: Is the text box 'grouped' to the chart? If so, it is treated as part of the chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, Thank you for your reply. That is certainly true when I place a text box on a worksheet but when it is on a chart the "Print Object" option is not available; not greyed out, just not there. Andrew "Bernard Liengme" wrote: 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 . . |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I prevent a text box from printing in XL2007?
I followed what you did: cut and paste a text box to a chart
I agree that the Print boxes have disappeared in the Properties dialog of Format Shape However, this method also groups the box and the chart - if I move the chart the box moves with it so they are grouped If I use the command Insert | Text box and draw the box over the chart, then I get a box that is not grouped and I can set the print properties. Note that the chart must NOT be selected before you draw the box as this will group the two. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, It is not grouped to the chart. If I create a text box on a worksheet I see the "Print Object" checkbox; if I cut it and paste it to the chart that option is gone. Put it back on the sheet and it's there. It certainly appears that this functionality has been removed in going from XL2003 to XL2007. -- Andrew "Bernard Liengme" wrote: Is the text box 'grouped' to the chart? If so, it is treated as part of the chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, Thank you for your reply. That is certainly true when I place a text box on a worksheet but when it is on a chart the "Print Object" option is not available; not greyed out, just not there. Andrew "Bernard Liengme" wrote: 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 . . |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I prevent a text box from printing in XL2007?
I should also have said: rather than cut & paste the text box into chart,
you can also drag the box over the chart, and the two will not be grouped. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, It is not grouped to the chart. If I create a text box on a worksheet I see the "Print Object" checkbox; if I cut it and paste it to the chart that option is gone. Put it back on the sheet and it's there. It certainly appears that this functionality has been removed in going from XL2003 to XL2007. -- Andrew "Bernard Liengme" wrote: Is the text box 'grouped' to the chart? If so, it is treated as part of the chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" wrote in message ... Bernard, Thank you for your reply. That is certainly true when I place a text box on a worksheet but when it is on a chart the "Print Object" option is not available; not greyed out, just not there. Andrew "Bernard Liengme" wrote: 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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent printing a sheet | Excel Discussion (Misc queries) | |||
| Prevent Printing | Excel Discussion (Misc queries) | |||
| xl2007 text import tool | Excel Discussion (Misc queries) | |||
| Prevent color printing | Excel Discussion (Misc queries) | |||
| How to prevent user from printing in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
