Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Startup for a Macro
How can I automatically start a macro when a specific .xls starts up?
|
#2
|
|||
|
|||
call the macro autoexec
|
#3
|
|||
|
|||
Private Sub Workbook_Open()
your code or macro name here End Sub To access the Thisworkbook module, right-click on the Excel logo just left of "File" on menu. Select "View Code". In dialog box drop-down at top left select Workbook and the Private Sub Workbook_Open().........End Sub will be inserted. Copy your macro code between the Open() and End Sub lines. Or just enter the macro name, assuming the macro is in the same workbook. If not in the same workbook, perhaps in Personal.xls or an Add-in, go to ToolsReferences and checkmark the reference to use. Save/Close and reopen. Gord Dibben Excel MVP On Mon, 2 May 2005 14:19:11 -0700, "gspirrison" wrote: How can I automatically start a macro when a specific .xls starts up? |
#4
|
|||
|
|||
dlw
In Excel in a General Module you would name it Auto_Open In the Thisworkbook Module it would be Workbook_Open Gord Dibben Excel MVP On Mon, 2 May 2005 14:38:03 -0700, dlw wrote: call the macro autoexec |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Startup for a Macro
I have code I place in In Excel in a General Module with name Auto_Open.
When I hold the shift key down, it still runs. Is there a way to turn off with VBA code? "Gord Dibben" wrote: dlw In Excel in a General Module you would name it Auto_Open In the Thisworkbook Module it would be Workbook_Open Gord Dibben Excel MVP On Mon, 2 May 2005 14:38:03 -0700, dlw wrote: call the macro autoexec |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Startup for a Macro
You sure the code runs?
Holding down Shift Key should prevent the code from running but will not prevent the "this workbook contains macros" message. Test with this in a new saved workbook. Sub auto_open() MsgBox "hello" End Sub Gord On Tue, 5 Jan 2010 07:19:01 -0800, DogLover wrote: I have code I place in In Excel in a General Module with name Auto_Open. When I hold the shift key down, it still runs. Is there a way to turn off with VBA code? "Gord Dibben" wrote: dlw In Excel in a General Module you would name it Auto_Open In the Thisworkbook Module it would be Workbook_Open Gord Dibben Excel MVP On Mon, 2 May 2005 14:38:03 -0700, dlw wrote: call the macro autoexec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help? start macro automatic in excel | Excel Worksheet Functions | |||
Run a Macro on Startup for Specific Spreadsheet | Excel Worksheet Functions | |||
running macro at automatic time intervals | Excel Worksheet Functions | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) |