Chapter 7. Macro Hacks

     

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



Excel Hacks
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets
ISBN: 0596528345
EAN: 2147483647
Year: 2003
Pages: 136

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net