Microsoft Excel Question:
Download Questions PDF

How do I have EXCEL execute a macro automatically upon starting EXCEL?

Answer:

Rename the macro to be AUTO_OPEN.

Or - add the macro to the Workbook_Open procedure on the code pane for ThisWorkbook.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I speed up my Macro execution?How can I format a worksheet to have alternating green and white rows like a "greenbar" report?