Can the text box outline be turned off for printing?
B Bob Umlas Aug 12, 2004 #2 Sure - click the border of the text box, then use Format/Text Box, select the Colors and Lines tab, for Line, select "No Line" Bob Umlas Excel MVP
Sure - click the border of the text box, then use Format/Text Box, select the Colors and Lines tab, for Line, select "No Line" Bob Umlas Excel MVP
J jeff Aug 12, 2004 #3 Hi, Yes. Tools--> Options--> view: objects area - uncheck show all. However this may not satisfy your long-term needs as you'll have to turn it back on to view and for other sheets. I don't know of an other way short of using VBA to turn off temporarily during printing, and then resetting. jeff
Hi, Yes. Tools--> Options--> view: objects area - uncheck show all. However this may not satisfy your long-term needs as you'll have to turn it back on to view and for other sheets. I don't know of an other way short of using VBA to turn off temporarily during printing, and then resetting. jeff
D Dave Peterson Aug 12, 2004 #4 And if it's a textbox from the Control Toolbox toolbar. Show that control toolbox toolbar and click the design mode icon. rightclick on the textbox and choose properties Look for BorderStyle and change it to: 0 - fmBorderStyleNone (remember to toggle the design mode to off.)
And if it's a textbox from the Control Toolbox toolbar. Show that control toolbox toolbar and click the design mode icon. rightclick on the textbox and choose properties Look for BorderStyle and change it to: 0 - fmBorderStyleNone (remember to toggle the design mode to off.)