Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load Macro at start up?
open the workbook. Go to the VBE (alt+F11), look in the project explorer for
your workbook, select the ThisWorkbook entry for your workbook. Double click on it and it should open the ThisWorkbook Module. In the left dropdown at the top of the module, select Workbook and from the right dropdown select Open. At any point in this process you may see the procedure declaration for the Workbook_Open event appear in the module. (All steps will guarantee it). Private Sub Workbook_Open() End Sub put your code in that Event or call you existing sub from that event. If you want to learn what events are available, see Chip Pearson's site: http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "MJ Antoszkiw" wrote in message ... How could I load a macro as soon as the workbook is opened? Thanks. MJ Antoszkiw. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO TO LOAD AN ADDIN | Excel Discussion (Misc queries) | |||
Macro to Load Data from ver 1 to ver 2 | Excel Discussion (Misc queries) | |||
Disabling an 'on load' macro | Excel Worksheet Functions | |||
how do i load a dechex macro? and from where? | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions |