MS Excel Working with MacroMS Excel - Working with Macro
Speed Up Code While Halting Screen Flicker
Run a Macro at a Set Time
Use CodeName to Reference Sheets in Excel Workbooks
Connect Buttons to Macros Easily
Create a Workbook Splash Screen
Display a "Please Wait" Message
Have a Cell Ticked or Unticked upon Selection
Count or Sum Cells That Have a Specified Fill Color
Add the Microsoft Excel Calendar Control to Any Excel Workbook
Password-Protect and Unprotect All Excel Worksheets in One Fell Swoop
Retrieve a Workbook's Name and Path
Get Around Excel's Three-Criteria Limit for Conditional Formatting
Run Procedures on Protected Worksheets
Distribute Macros
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.
One drawback with recorded macros in Excel is that the code produced is often very inefficient. This can mean macros that should take a matter of seconds to complete often take a lot longer and look very unsightly. Also, when you write macros using the macro recorder, all keystrokes are recorded, whether they are meant to be or not. This means that if you make an error and then correct it, the keystrokes required to complete those actions also will be recorded in your macro code.