4.3. Creating A Procedure For Excel
The procedure you'll create for Excel is short but helpful: when the user runs Excel, the procedure maximizes the Excel window and opens the last file worked on. The procedure also illustrates some useful techniques, including how to:
Write a macro that executes when an application first starts up
Work with events
Use the Object Browser to find the objects, methods, and properties you need
Follow these steps to create the procedure:
Start Excel if it's not already running.
If your Personal Macro Workbook is currently hidden, click the Unhide button in the Window section of the View tab on the Ribbon. Select PERSONAL.XLSB in the Unhide Workbook list box, and then click the OK button.
Press Alt+F11 to open the Visual ...