Cursor in A2 upon opening sheet

[Jean-Paul De Winter]

Hi,
A few days ago I asked for a way to get my cursor in (let's say) cell
A
upon opneing a sheet.
This was the answer I got:

Open you VBA editor. Double click on each sheet, chose event
"activate" insert "Range("A1").select"

This works when I move between worksheets but not upon OPENING the
initial workbook....
How can I make the cursor move to cell A2 when I open the file and
when I move from one worksheet to another?
Thanks
JP

 

[Frank Kabel]

Hi
in the VBA editor double click on 'ThisWorkbook' and insert the
following code:
Private Sub Workbook_Open()
worksheets("Sheet1").activate
Range("A1").select
End Sub