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 |
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 |
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 |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com