Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splash screen | Excel Discussion (Misc queries) | |||
Relocating Splash Screen | Excel Discussion (Misc queries) | |||
make a splash screen appear first | Charts and Charting in Excel | |||
Splash Screen Startup | Excel Discussion (Misc queries) | |||
suppressing the splash screen | Excel Discussion (Misc queries) |