Locking Table Size

T

TiffanyH

I'm using tables for an employee appraisal and I want to lock the size of the
table so they can type in it, but it won't increase in size if they keep
typing beyond the size on the screen. Anything out there for that?
 
S

Suzanne S. Barnhill

Set the rows to an exact height and the columns to a preferred width, with
auto resizing disabled.
 
T

TiffanyH

Ok great! Now that the tables are locked in size, is there anyway to not
allow the use to continue typing beyond the cell size?
 
S

Suzanne S. Barnhill

No, you just have to hope they have sense enough to stop when their typing
starts disappearing. In a protected form, you can limit the number of
characters, but that doesn't prevent them from pressing Enter.
 
Top