Home » Writing-Excel-Macros

Setting up Excel to Allow Macros

Excel has built-in security, to protect against viruses that may be passed to your computer via Excel Macros. These are controlled by 4 security settings. If you want to run macros in your Excel workbook, you may need to ensure that you have the correct security settings.

The Visual Basic Editor

Excel has its own Visual Basic Editor, which holds your macro code and links into your Excel Workbook. The VB editor assists you with writing code, by flagging errors that do not satisfy Visual Basic coding rules. The editor also contains debugging software, which assists you with tracking and detecting errors in your code.

Recording Macros

Excel's macro recording functionality is a useful way of efficiently performing simple repetitive tasks. This feature of Excel can also be used to assist in writing more complex macros, particularly if you need help in figuring out a way of writing code for a particular task in VBA.

Excel VBA Tutorial

In order to assist beginners with Excel VBA programming, the following mini tutorial takes you through some of the more commonly used Visual Basic commands.

Further Information

If you want more details on writing Excel Macros the University of Durham provide an excellent Introductory Guide to Using Macros in Excel 2003 (link opens in a new window).