splash screen
 

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

splash screen
 

Create a short cut to the file
In Windows Explorer, right click on the file and select <Create Shortcut
Drag the shortcut file to Documents and Settings\(User name)\Start
Menu\Programs\Startup

This will open Excel and that file on booting up the computer.

Regards.

Bill Ridgeway
Computer Solutions

"K11ngy" wrote in message
...
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

splash screen
 

Hi,

Things have move on since autoexec.bat!!

In Excel you use the worksheet_open event. Alt+F11 then double click
workbook and paste this in.

Private Sub Workbook_Open()
Worksheets("Menu").Select
End Sub

Mike

"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

splash screen
 

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