Not printing text box borders?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Vocks - 03 Jun 2004 16:10 GMT

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

Reply to this Message

Earl Kiosterud - 03 Jun 2004 19:42 GMT

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. :)

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> 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

Reply to this Message

Gary Vocks - 03 Jun 2004 20:51 GMT

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,
>
[quoted text clipped - 12 lines]
> >
> > Gary Vocks

Reply to this Message

Earl Kiosterud - 04 Jun 2004 03:48 GMT

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.

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Earl,
>
[quoted text clipped - 36 lines]
> > >
> > > Gary Vocks

Reply to this Message

Gary Vocks - 04 Jun 2004 22:04 GMT

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

> Gary,
>
[quoted text clipped - 52 lines]
> > > >
> > > > Gary Vocks

Reply to this Message