Excel 2019 Bible

Part VI: Automating Excel If you use an object variable (as described in “Simplifying object references” earlier in this chapter ...

1027 C H A P T E R 48 Creating Custom Excel Add-Ins IN THIS CHAPTER Understanding add-ins Converting a workbook to an add-in F o ...

Part VI: Automating Excel As previously noted, Excel ships with several useful add-ins, and you can acquire other add-ins from t ...

Chapter 48: Creating Custom Excel Add-Ins 48 Pressing Alt+T followed by I is a much faster way to display the Add-Ins dialog box ...

Part VI: Automating Excel To provide easier access After you identify the location of your add-in, it appears in the Add-Ins dia ...

Chapter 48: Creating Custom Excel Add-Ins 48 Choose File ➪ Options ➪ Add-Ins. Select Excel Add-Ins from the Manage drop-down li ...

Part VI: Automating Excel This book’s website at http://www.wiley.com/go/excel2019bible contains the original version of the wor ...

Chapter 48: Creating Custom Excel Add-Ins 48 To test it, save the XLSM version of the workbook, close it, and then reopen it. Wi ...

Part VI: Automating Excel Creating the user interface for your add-in macro At this point, the future add-in is missing one key ...

Chapter 48: Creating Custom Excel Add-Ins 48 Select the Lock Project for Viewing check box. Enter a password (twice) for the pr ...

1037 Index Symbols ! (exclamation point) in link formula syntax, 638 when referencing cells in other workbooks, 224 when referen ...

Index | (vertical bar) as insertion point, 36 in workbook names, 161 A About Excel command, 911 ABS function, 242 absolute refer ...

Index descriptive statistics tool, 759 exponential smoothing tool, 759–760 F-test tool, 760, 761 Fourier analysis tool, 760 hist ...

Index advantages/disadvantages, 401 contracting, 410 creating, 400–401 creating array constants from values in a range, 411–412 ...

Index BeforeClose workbook event, 1000, 1002–1003 BeforeDoubleClick worksheet event, 1003 BeforePrint workbook event, 1000 Befor ...

Index changing shape, 100–101 deleting, 35, 102 editing, 101 formatting, 99–100 hiding, 101 inserting, 98–99 reading, 101 select ...

Index area charts, 476–478 bar charts, 471 box & whisker charts, 484–485 bubble charts, 479, 480 column charts, 469–471 copy ...

Index Clear Rules command, 142 Close button, 21 closing add-ins, 1028 task panes, 21 UserForms, 972 windows, 54 workbooks, 164 B ...

Index summing values that meet two or more conditions, 306–307 validating conditional data, 298–299 Conditional Formats option, ...

Index Cube functions, 833–834 currency applying regional currency format to text, 268 Currency data type, 1025 Currency number f ...