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…]
