hi
see this site..
http://www.mrexcel.com/archive/VBA/522.html

it explains how to set up a worksheet change event to autofit the activecell
on enter. complete with code.

Regards
FSt1

"KB" wrote:

I need cells to automatically adjust to fit text entered.
This text will be entered by others after I complete the workbook.

Thanks for your help!