While macros can be created using code, they can also be created by having Excel record your actions. It is very simple. I illustrate, in the accompanying video, how to record a macro in Excel using ...

Excel macros defined An Excel macro is a series of commands stored in a workbook. A macro can replace actions that are as simple as a few menu choices and mouse clicks.

Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Creating a macro in Microsoft Excel allows you to program automatic tasks into a spreadsheet or template that can contain multiple commands or functions for easy access and use. After these macros ...

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 ...

Each Excel workbook contains links to screencasts streamed from vimeo.com. All screencasts are aggregated into a Macroeconomics with Excel channel (which is initially organized in the order listed ...

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 ...