1. Launch Excel and Enable Excel Macros.
Microsoft considers all macros a security risk and this can be a nuisance.
Do the following to enable the macros. This is a one-time step for all macros.
- Launch Excel; click the Orb (formerly the File Menu); choose Excel Options
- Click Trust Center, Trust Center Settings
- Macro Settings
- Enable All Macros
- Older versions of Office have similar settings.
2. Expose Developer Options
a. Click the "orb" (or File Menu), Excel Options
b. On the left, choose "Popular"
c. Click [x] Show Developer tab in the ribbon
d. Click OK and return to the sheet
a. Click File, Excel Options, "Customize Ribbon"
b. In the second-column ("Customize Ribbon: Main Tabs"), check [x] Developer
c. Click OK and return to the sheet
3. Enable Option Explicit Variables
In Office 2010 and above:
From any Blank Sheet, press Alt-F11 to open the VBA Editor
a. Select Menu "Tools", Options, [Editor Tab],
b. Check [x] Require Variable Declaration
This replaces the "Option Explicit" line you used to have to type in macros -- forcing you to declare variables before using - a recommended practice.
Parsing First and Last Names in Excel
Parsing City State Zip in Excel
SuperTrim in Excel
User Defined Functions in Excel