View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Kevin Lehrbass
 
Posts: n/a
Default excel-i want it to go to a certain cell when i 1st open the sheet

Hi Lindsey,

I can think of two options off the top of my head:
1) Go to the cell, save and close. The next time you open the workbook, the
active cell will be the same cell.
2) Use Excel Events. This requires programming Excel using VBA and when
done properly can be extremely useful !!! The desired cell will always be the
active cell regardless of what cell you are in when you hit save.

There are many excellent tutorials on the web (do a google search "excel vba
event autoopen"). Here is one link from www.ozgrid.com
http://www.ozgrid.com/News/ExcelCust...oRunMacros.htm

Excel is an incredible program and it's so much fun learning !!!!

Good luck,
--
Kevin Lehrbass

www.spreadsheetsolutions4u.com


"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?