Cell Selection in Excel

[Guest]

Whenever I open a Worksheet/Workbook I want a particular cell, say A1, should
be selected irrespective of which cell was selected when I last saved the
Worksheet/Workbook. Any suggestions pls.?

 

[Bob Phillips]

Private Sub Workbook_Activate()
ActiveSheet.Range("A1").Select
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Range("A1").Select
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)