Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

     

Hacks #81-94

Section 81.   Speed Up Code While Halting Screen Flicker

Section 82.   Run a Macro at a Set Time

Section 83.   Use CodeName to Reference Sheets in Excel Workbooks

Section 84.   Connect Buttons to Macros Easily

Section 85.   Create a Workbook Splash Screen

Section 86.   Display a "Please Wait" Message

Section 87.   Have a Cell Ticked or Unticked upon Selection

Section 88.   Count or Sum Cells That Have a Specified Fill Color

Section 89.   Add the Microsoft Excel Calendar Control to Any Excel Workbook

Section 90.   Password-Protect and Unprotect All Excel Worksheets in One Fell Swoop

Section 91.   Retrieve a Workbook's Name and Path

Section 92.   Get Around Excel's Three-Criteria Limit for Conditional Formatting

Section 93.   Run Procedures on Protected Worksheets

Section 94.   Distribute Macros

Категории