Subscribe
Tutorial search

Excel Macros Tutorials


Sort by:
Excel Macro
Excel Macro
Creating macros in Excel differs from one version to another. Please choose your version.
Difficulty:
Customizing the Office 2007 Ribbon
Customizing the Office 2007 Ribbon
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.
Difficulty:
Run Procedures on Protected Worksheets
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Avoid that problem with the following tutorial.
Difficulty:
Distribute Macros
Distribute Macros
Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go.
Difficulty:
Connect Buttons to Macros Easily
Connect Buttons to Macros Easily
Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons.
Difficulty:
Excel Display a
Excel Display a
Have you ever had one of those macros that seem to take forever to complete? If this is a problem with your macro, you can have Excel display a "Please Wait" message to the user.
Difficulty:
Speed Up Code While Halting Screen
Speed Up Code While Halting Screen
When you record macros from within Excel, the code it generates often produces screen flicker, which not only slows down your macro, but also makes the macro's activity look very disorganized. Fortunately, you can eliminate screen flicker while at the same time speeding up your code.
Difficulty:
Prevent Unnecessary Prompts
Prevent Unnecessary Prompts
The types of prompts we are talking about are those that ask you whether you want to enable macros (when you do not have any), or whether you are sure you want to delete a worksheet.
Difficulty:
Writing Your Own Macros
Writing Your Own Macros
This tutorial introduces you to the basics of writing simple procedures and functions, as well as how to get around in the Visual Basic Editor, which is the tool that VBA provides for writing macros by hand.
Difficulty:
How To Get the Weekday as Text in Excel VBA
How To Get the Weekday as Text in Excel VBA
This tutorial explains how to get the weekday as text in Excel, using VBA, and giving a function to do the job. We also give a method which avoids using macros, for comparison.
Difficulty:
Excel 4.0 Macro Reference
Excel 4.0 Macro Reference
Microsoft Excel 2001 and later allows you to continue to use and maintain Excel 4.0 macros (XLM macros) that have not been upgraded to Visual BasicÃ" for Applications (VBA). Although you cannot record new Microsoft Excel 4.0 macros in Microsoft Excel 2001 or later, you can run and modify them.
Difficulty:
Unhiding multiple sheets at the same time
Unhiding multiple sheets at the same time
Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros
Difficulty:
Removing #DIV/0! errors from your spreadsheets
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
Difficulty:
Protecting and unprotecting all the sheets in your spreadsheet
Protecting and unprotecting all the sheets in your spreadsheet
How to protect and unprotect all the sheets in yout spreadsheets in one go using the same password with the AssumeIT macros
Difficulty:
Running sensitivities that involve macros
Running sensitivities that involve macros
Shows how to run the required macros when run the sensitivities with the AssumeIT macros
Difficulty:
Search Term(s) (1): macros