You could also use a macro named Auto_Open in a General module:

Option Explicit
Sub Auto_Open()
application.goto worksheets("sheet9999").range("a1"), scroll:=true
End Sub

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

K11ngy wrote:

Would someone kindly advise code I need to write in macro so that when I open
Excel it opens with a particular worksheet (Main menu) I assume I would also
name macro "Autoexec" ??

Thanks

Steve King

--

Dave Peterson