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