View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to get Excel 2003 to open to specific cell refernece!

You can have a macro run each time the workbook opens.

Option Explicit
Sub Auto_Open()
application.goto worksheets("sheet9999").range("x777"), scroll:=true
end sub

Change the worksheet name and cell address to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

I would like for my Excel 2003 worksheet to open at a specific cell
reference. Is this possible.? My knowledge of Excel is very limited so
please be explicit.

Thanks in advance.


--

Dave Peterson