View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Setting cursor location on opening

hi
where is the currents date? does it move?
assuming it is stationary and Sheet 1 A1....
Private Sub Workbook_Open()
Sheets("sheet1").Activate
Range("A2").Select
End Sub
This is workbook event code.
put it in a workbook module.

Regards
FSt1

"Howard Irwin" wrote:

I'm using Excel 2003. When I open a worksheet, I would like the cursor to
move to a cell to the right of a cell with the current date in it. Is there
an easy way to do this?
--
Howard Irwin