Excel 2007 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 2007 VBA Programming Functions

Excel 2007 alone is a powerful tool for data analysis and number-crunching. But when you add VBA programming to your Excel workbooks and spreadsheets, your opportunities for transforming simple data into [more…]

Excel 2007 VBA Programming For Dummies Cheat Sheet

You can do a lot with Excel and VBA just by recording macros, but you need to really dig into Excel VBA programming if you want to turn your Excel workbooks and spreadsheets into supercharged solutions [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…]

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.