Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i run an autoexecute macro in excel
how do i set a macro to autoexecute when an excel worksheet is opened - i can
find no data in help for autoexecute |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i run an autoexecute macro in excel
you need to put your macro in a worksheet module or a workbook module for the workbook module right click on the xl symbol at the top left of the sreen and select view code and drop the box to select workbook, then in the right box select the event you want for the macro to start, such as workbook open will start your macro when you open your workbook, there is lots of info on workbook and worksheet events -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=558879 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i run an autoexecute macro in excel
Either use a Workbook_Open sub in Thisworkbook module
or Auto_Open sub in a general module. Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 06:26:02 -0700, robin morris <robin wrote: how do i set a macro to autoexecute when an excel worksheet is opened - i can find no data in help for autoexecute |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Outlook Alias into an Excel 2003 macro | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |