Author Webcasts from Que Publishing

Webcast Archive: Introduction to Excel Macros

Presented by Bill Jelen

If you are running Excel in a Windows environment, you have a copy of Visual Basic for Applications hiding behind the worksheet cells, waiting to automate your Excel tasks. Unfortunately, Microsoft makes it hard to get into macros with some unfortunate settings in the Excel macro recorder.

This webcast illustrates the frustrations that people run into when using the macro recorder, and the two simple settings that can alleviate those frustrations. You will find yourself wondering why Microsoft doesn't use these settings by default.

MrExcel Bill Jelen takes a quick look at the Visual Basic Editor, and show you a few lines of code that the macro recorder will never produce. These simple additions to the recorded code will allow you to add flexibility to your macros.

Bill JelenBill Jelen, Excel MVP and the host of, is the author of 32 books about Microsoft Excel and a contributing editor to He writes the monthly Excel column for Strategic Finance magazine. Before founding, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company.