Hello Vicki

First of all create the template, then select the cells that you want
users to be able to type in. Once you've selected these right mouse
click, a menu will appear then select Format Cells, select Protection &
then remove the tick from the Locked box. Then select the Tools menu,
then Protection option & then Protect Sheet option enter a password.
This will now only allow users to enter info. into the cells you
previously selected & leave the template part untouchably unless you
unprotect the sheet.

Hope this helps


--
robmeister
------------------------------------------------------------------------
robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364
View this thread: http://www.excelforum.com/showthread...hreadid=380218