excel-i want it to go to a certain cell when i 1st open the sheet
Lindsey
Right-click on the Excel Icon left of the File command on menu(assuming your
window is maximized) and "View Code"
If window not maximized r-click on the logo in title bar.
Copy/paste this into that module.
Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub
Edit to your sheet name and range.
Save and close workbook. Re-open.
Gord Dibben Excel MVP
On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey"
wrote:
when i open a spreadsheet that i created, how do i get the cursor to go to
the cell i want it to.. in this spreadsheet i will have to enter information
in different columns and i want it to automatically go to the first cell
under the first column. how can i do this?
|