لطفا منتظر باشید ...
• Table of Contents• Reviews• Reader Reviews• Errata• AcademicExcel HacksBy
David Hawley, Raina HawleyPublisher: O''ReillyPub Date: March 2004ISBN: 0-596-00625-XPages: 304The tips and tools in Excel Hacks
include little known "backdoor" adjustments for everything
from reducing workbook and worksheet frustration to hacking
built-in features such as pivot tables, charts, formulas and
functions, and even the macro language. This resourceful,
roll-up-your-sleeves guide shows you new ways to make Excel
do things--from data analysis to worksheet management to
import/export--that you never thought possible.
Excel Hacks increases productivity with
Excel and gives you hours of "hacking" enjoyment along the
way.
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
