Macros & Programming

View:

Sorted by:

How to Set the Macro Security Level in Excel 2007

Security is an important issue when you're working with Excel 2007 macros. If you open worksheets containing macros from outside sources, these macros could be harmful to your computer. By default, Excel [more…]

How to Add an Excel 2007 Macro to the Quick Access Toolbar

You can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker access to a macro than using the Macro dialog [more…]

How to Automate Tasks with Macros in Excel 2007

You can use macros in Excel 2007 to save time by automating tasks that you perform frequently. A macro is a series of commands grouped together that you can run whenever you need to perform the task. [more…]

How to Run an Excel 2007 Macro

After you record a macro in Excel 2007, either by using the macro recorder or by creating it in Visual Basic for Applications (VBA), you run the macro to have it carry out the commands and keystrokes that [more…]

Saving and Using an Excel 2007 Macro-Enabled Workbook

When you're working with macros in Excel 2007, you save and open workbooks in a new macro-enabled workbook format (.xlsm) that provides added security. When you create a macro, you must use this format [more…]

Excel VBA Programming Functions

Visual Basic for Applications (VBA) gives experienced Excel users a wide range of options for creating Excel spreadsheets and customizing how they look and function. Speaking of functions, the table following [more…]

Excel VBA Programming For Dummies Cheat Sheet

If you’re an intermediate to advanced Excel user who wants to explore VBA programming, the Excel VBA functions and what they do is the place to start. [more…]

How to Record a Macro in Excel 2007

Excel macros allow you to perform repetitive tasks quickly through a keyboard shortcut. This Excel video tutorial shows you how to record a simple macro to help automate your Excel 2007 tasks. [more…]

How to Run Macros in Excel 2007

Excel macros allow you to perform repetitive tasks quickly, but after you create a macro, you need to know how to run it. This video tutorial shows you how to access the Macro dialog box or use a keyboard [more…]