Index

Symbols and Numerics

• = (equal sign), 76
• 64-bit Excel, 704–705
• 64-bit functions, 179

A

• AbortProc variable, 186
• absolute references, macros, 23–26
• Access, 354–356
• Activate event, 190, 191, 197
• Activate method, 310–311
• activating charts, 310–311
• active cell, chart data, 324–325
• active chart, 306, 313
• active workbook, ADO in, 395–397
• ActiveX controls, 8, 9
  • versus form controls, 11
  • Toolbox, 475–477

• AddIn object, 589–593
• AddinInstall event, 190
• add-ins, 569
  • accessing as workbook, 592–593
  • Add-in Manager, 572–580
  • COM, 572
  • creating, 574–575, 577
  • descriptive information, 577
  • distributing, 579
  • files, 6
  • installation, 578–579
  • modifying, 580
  • password-protected, 14
  • performance, 593–594
  • procedures, 583–587
  • reasons for, 570–572
  • testing, 579
  • troubleshooting, 594–597
  • versus workbooks, 569–570

• AddIns collection
  • adding items, 587–588
  • removing items, 588...