If you have simple tasks that you need to perform in Excel often, you can actually “teach” Excel to do them for you by recording a macro.

Excel macros may be confusing at first glance, but they're easy to create and can save you a lot of time ...

Click to download a workbook and open in Excel; make sure to enable macros for full functionality. The workbooks contain screencasts that explain what to do and include tasks that can be assigned.

Excel VBA allows you to call an external function or module with a simple "=NameOfFunctionToCall" entry in the code syntax. However, in .NET applications, you should always use the "Call ...

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...

Excel Workbooks Click to download a workbook and open in Excel; make sure to enable macros for full functionality. The workbooks contain screencasts that explain what to do and include tasks that can ...