Unlock the cells where the user is to enter data then protect the worksheet
In the protection dialog (XL 2003 and XL2007) limit the users to unlocked
cells
Now user cannot see or change formulas
This is OK to prevent careless errors but is no great security since there
are dozens of password un-lookers around
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kay" wrote in message
...
Is there a way for me to do the following in a worksheet?
Hide formulas and lock them from editing
Lock cells to prevent editing
For worksheets that require information filled in- is there a way to
automatically let you do the first cell before moving on to the next


--
KK