How do I set a page's home cell

D

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?
 
J

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
 
Top