View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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?