Macros & Programming - How-To Help and Videos

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

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com