splash screen

[K11ngy]

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

 

[Bill Ridgeway]

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

 

[Mike H]

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

 

[Dave Peterson]

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

Option Explicit
Sub Autpen()
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