hi,

after protecting a sheet, the focus of a cell moves to the next possible
cell by hitting the tabkey.

like in my vb programs, i'd like to move the focus to the next available
cell by pressing the returnkey as well. i found a routin earlier but it
won't work. also i would only like to allow the input of only numbers on the
whole sheet. how can this be done and where would this event go?

thanks,

jerry

you can use the sheet's Change event ... this is fired whenever something is
entered. The changed cell is passed to the sub so that you can test it.

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not IsNumeric(Target.Value) Then
      Target.Value = 0
  End If
End Sub

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------