|Subject:||Re: Selecting test to not print|
|Posted by:||Dave Peterson (peters…@verizonXSPAM.net)|
|Date:||Fri, 24 Aug 2007|
Rightclick on the textbox (on the edge)
choose "Format Text Box" or "format control"
(depends on where you got the textbox--from the Drawing toolbar or the control
Then choose the properties tab and uncheck Print Object.
If you want to hide text in a cell, you can format it with a custom number
or even give them a font color to match the fill color.
(manually, via a macro or via format|Conditional formatting)
Ron de Bruin shares a macro method:
> Can I select a text box or a group of cells so that whatever I type is seen
> on my screen but is not visible on the print out?
Selecting test to not print posted by jwm5566 on Fri, 24 Aug 2007