Not printing text box borders?

  • Thread starter Thread starter Gary Vocks
  • Start date Start date
G

Gary Vocks

I am trying to design a form in Excel 2002 and I'd like to use text boxes
but I'd like them to print without a border. I can't seem to find any way
to turn the border off. Is there a way to format the text box so I can do
this? TIA.

Gary Vocks
 
Gary,

Is this a worksheet or UserForm? By "print," do you mean it shows on the
screen but doesn't print (to paper)?

If you want to remove the border entirely (screen and print), and you're
using a text box from the Control Toolbox (Sheet or UserForm), set its
BorderStyle property to fmBorderStyleNone. It's probably there now, so set
it to the other, fmBorderStyleSingle, then back. Don't ask. :)
 
Earl,

Thank you very much for your help. I wasn't very clear what I was trying to
do when I asked the question but the information you gave pointed me in the
right direction.

What I was doing was making a worksheet into a form to print and submit. I
had used the "Insert Textbox" command from the "Draw" toolbar to type some
repetitive information into a number of textboxes on the form. The problem
that I was having was when I printed the form all the textboxes had a border
printed around them. I didn't want those borders but I couldn't figure how
to get rid of them. When I right-clicked on the box and clicked on "Format
Text Box" the only option I had was for "Font". Once I opened the "Control
Toolbox" right-clicking on the box gave me a full array of options under
"Format Text Box"including "Colors and Lines". That's what I needed!

Thanks, again!

Gary Vocks
 
Gary,

The text box in the Drawing Toolbar can be set up for no border.
Right-click it at it's gray selection box (not inside) - Format text box -
Colors and Lines tab - Line color: No line.
 
Thanks, again Earl. I had tried that but for some reason it did not give me
that option--even when I know that I was clicking on the gray selection box.
Oh well, I guess the gremlins were in my computer, again. They seem to be
gone now, though, and everything's working as it should.

Again, thank you very much.

Gary Vocks
 
Back
Top