Excel 2010 Macros & Programming

Sorted by:  

Windows Forms Controls in VSTO

VSTO contains two namespaces that hold classes that contain Windows Forms controls, which you can use on the Word documents or Excel worksheets. All controls in the [more…]

Excel Namespace Classes for Extending the Office Object Model in VSTO

In VSTO, the Microsoft.Office.Tools.Excel namespace contains classes that are relevant to the Microsoft Office Excel application. Here are the class names, along with short descriptions: [more…]

How to Run an Excel 2010 Macro

After you create an Excel 2010 macro, 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 2010 Macro-Enabled Workbook

When working with macros in Excel 2010, 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 a macro-enabled format [more…]

How to Set the Macro Security Level in Excel 2010

Security is an important issue when working with Excel 2010 macros. If you open workbooks containing macros from outside sources, these macros can be harmful to your computer. By default, Excel protects [more…]

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

You can assign a macro created in Excel 2010 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 Record a Macro to Automate Tasks in Excel 2010

You can use macros in Excel 2010 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…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com