Text Boxes Hidden

[Ed Davis]

I have a lot of text boxes that I am using as command buttons (calling
macros).
There is 1 text box that is placed between cells that are hidden until
needed. That 1 text box will not unhide when I
Unhide the columns that it resides. During test mode it works fine but when
I really need it to work it does not unhide.
I can not find where I can lock it .
Is there a way for me to use it the way that I want.

I used command button before but the Text boxes are much nicer looking.

 

[Billy Liddel]

Just a guess Ed, but double click the text box and on the Properties tab of
the Format text Box form make sure that the Move and resize option is
selected.

HTH
Peter

 

[Ed Davis]

It does not have that option.
It does when using buttons but it is not an option for text boxes.
It does allow you to shape to fit text. Using that it shrinks the box too
much. and the boxes are all different sizes.

 

[Shane Devenshire]

Hi,

Text boxes do have the property mentioned but don't double-click inside the
text box, instead double-click its border

 

[Shane Devenshire]

It comes to mind that if you are using 2007 you can't use the double-click
approach, instead right-click the border and choose Size and Properties...