Kay, the last part of you question..You can use the below code to make sure
the first cell is filled. Change the reference to suit your requirement.
Right click the sheet tab and paste the below code and try.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Trim(Range("A1")) = vbNullString Then
MsgBox "Enter data in cell A1"
Application.EnableEvents = False
Range("A1").Activate
Application.EnableEvents = True
End If
End Sub
--
If this post helps click Yes
---------------
Jacob Skaria


"Kay" wrote:

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