Automatically going to cell when spreadsheet opens (2000)

Topic

New Reply

Is is possible to assign a macro to go to a specific cell in a spreadsheet when the spreadsheet loads up?

Reply | Quote

Replies

Activate the Visual Basic Editor (Alt+F11)
Double click ThisWorkbook.
Enter code like this:

Private Sub Workbook_Open()
Worksheets(“Sheet3”).Select
Range(“P2”).Select
End Sub

Of course, you should substitute the appropriate sheet name and cell address.

Reply | Quote

Thats great thanks.

Reply | Quote

Right click on the sheet tab and choose View Code.
You will see two drop downs on the top of the window.
Select Worksheet from the first and select Activate from the second.
Inside the Private Sub Worksheet_Activate() procedure type: Range(“A1”).Select

(Change the range reference as needed!)

Reply | Quote