Cursor in A2 upon opening sheet

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

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
 
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
 
Back
Top