Mhelp4Ucom‎ > ‎Office 2007 ▼‎ > ‎Excel 2007 ▼‎ > ‎

How to create an auto running macro in Excel

                                               Contact us for Site Advertising Rates & Metrics    

                                                                           

                                                                                                                                                Report Errors & Bugs

 


                                          How to create an auto running macro in Excel

                                                                         This Mhelp clip will show you how to create an auto running macro in Excel.

                                                                                     This Mhelp clip has twelve steps.
                                                                                     1 - Click the View tab.
                                                                                     2 - Under Macros, click Macros. A menu will appear.
                                                                                     3 - Click View Macros. A dialog box will appear.
                                                                                     4 - Under Macro name, type a name for the macro.
                                                                                     5 - Click Create. A window will appear.
                                                                                     6 - Type the code for your macro. 
                                                                                     7 - Close the window when finished.
                                                                                     8 - Click the View tab.
                                                                                     9 - Under Macros, click Macros. A menu will appear.
                                                                                    10 - Click View Macros. A dialog box will appear.
                                                                                    11 - Click the macro that was created.
                                                                                    12 - Click Run.

                                                                               Note: This will make the word "Hello" appear every time you open the workbook.

                                                                              This concludes the Mhelp clip.