How do I set a page's home cell

[Dan Haislet]

I need to set cell A1 as the home cell on each page of an Excel Workbook so
that no matter what I do in another cell, when I press enter, the cursor
moves back to the home cell. Is this possible?

 

[Jason Morin]

For each worksheet, try:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Count > 1 Then Exit Sub
Range("A1").Select
End Sub

Right-click the ws tab, View Code, and paste in the code
above.

HTH
Jason
Atlanta, GA