Index_T

T

Tab delimited format, 294

Tab Docking option, 74

Tab key, 77, 78, 84

Tab object, 854

tab order, in forms, 403-4

Tab parameter, 290

tab width setting, 78

TabIndex property, 403, 407

Table Options command, 708

TableRange1 property, 716, 728

TableRange2 property, 716, 728

tables

accessing all fields of, 655

defining relation between data field of, 634

HTML, importing into Excel, 739-40

macro for simplifying input to, 15-17

relating data from different, 623-25

relations among, 622-23

restricting, 632

selecting fields, 629

what they are, 571

when a database query affects several, 634

TabStop property, 404, 407

Tag property, 407

TakeFocusOnClick property, 20, 444

Tan function, 244

temp subfolder, 271

templates. See also smart forms

chart, 338

databases linked to, 505-7, 508

empty, opening, 497-98

included with Excel, 509

macro, 335-37

viruses in, 182-83

wizards, 496, 505, 507-8

Templates directory, 52, 62

TemplatesPath property, 52, 284

temporary folder, 271-72

Terminate event, 436

terminate procedures, 164

terminating Excel, 59

test files, generating for incoming directory, 684-85

Test_Classes procedure, 168

TestAndMarkForEuroConversion procedure, 350-52

TestAppEvents module, 152

TestClasses module, 168

TestForValidInput: function, 614-15

TestIfWeekend function, 521-22

testmethod method, 129

text boxes

creating, 470

events and, 410-11

properties of, 411

text files, 276-78, 282

exporting, 294-95. See also Mathematica lists, exporting for

syntax summary, 304

importing, 286-94

and OpenText method, 289-92

overview, 286

and QueryTable object, 292-94

syntax summary, 304

Text Import wizard, 287-89

text, importing to Excel 2000, 54

Text Only property, 461

Text property, 194

Text (Tab delimited) format, 294

TextBox object, 855

TextEffectFormat object, 560, 855

TextFilePromptOnRefresh property, 294

TextFrame object, 560, 855

TextQualifier parameter, 291

TextStream object, 276-78, 303, 855

This Workbook object, 76, 82

ThisWorkbook module, 548

ThisWorkbook property, 128, 216

ThousandsSeparator parameter, 291

ThreeDFormat object, 560, 855

TickLabels object, 536, 856

time events, 149-50

Time function, 250, 253, 265, 266

timed saves, 80

Timer function, 250, 265

times. See dates and times

TimeSerial function, 248, 250, 265

TimeValue function, 250, 265

TIMEVALUE worksheet function, 253, 266

Title property, 169

titles of charts , 532

To keyword, 115

TODAY( ) formula, 503

TODAY function, 253, 266

toggle buttons , 421-22

Toggle Folders icon, 71

ToggleButton object, 856

toolbars , 58

for all users, 466

attaching to files, 464-65

for changing sheets, 479-82

creating new, 460

defining extensive menus in, 463-64

deleting, 14, 465-66

in development environment, 60

differences compared to Excel 5/7, 482-83

display options, 328

editing manually, 458-59

file locations for, 465-66

hiding and unhiding

for freestanding applications, 489-90

manually, 458

via program code, 472

improved visual appearance, 482

information on, 334

inserting Custom Menu Item entry to, 81

with listboxes, 479-82

protection mechanisms for, 326

saving changes to, 464

user -defined, 334

tools

editing, 460-61

groups, 463

images, 461-62

labels, 461

macros assigned to, 463

where saved, 15

ToolsAdd-insAutosave option, 80

ToolsCustomize dialog, 458-59

ToolsError Checking command, 49

ToolsFormula AuditingShow Watch Window command, 50

ToolsGoal Seek command, 211

ToolsMacro command, 5, 80

ToolsMacroMacros command, 12

ToolsMacroRecord New Macro command, 11, 82

ToolsMacroSecurity, 180

ToolsMacroSecurityTrusted SourcesTrust Access to Visual Basic command, 154

ToolsMacroStop Recording command, 82

ToolsMacroVisual Basic Editor command, 69

ToolsMacros, 110

ToolsMail Merge command, 591

ToolsOptions command, 326-27

ToolsOptions form, 73

ToolsOptionsCalculation, 249

ToolsOptionsChart, 532

ToolsOptionsDocking command, 71

ToolsOptionsEditor window, 78

ToolsOptionsGeneral, 201

ToolsOptionsModule General, 241

ToolsOptionsSave command, 80

ToolsOptionsView command, 19, 28

ToolsProtectionAllow Users To Edit Ranges command, 322-23

ToolsProtectionProtect sheet command, 320

ToolsProtectionProtect Workbook command, 321

ToolsReferences command, 166, 309, 645, 646

ToolsReferencesBrowse command, 132

ToolsShare WorkbookEditing protocol, 324

ToolsVBA Project PropertiesProtection command, 324-25

ToolsVBAProject Properties command, 75

(Top 10) setting, 584

Top function, 713

Top property, 218

TopLeftCell property, 561

TotalList, 689

TotalSize property, 269, 302

tracking down data, 582-83

transferring data

into database, 676-78

via clipboard, 228-31

transformation functions, 241-43, 245-46

TreeviewControl object, 856

trend lines, 531, 532-33

Trendline object, 536, 539, 856-857

Trendlines object, 857

trigonometric functions, 234

Trim function, 236

TristateDefault value, 276

TristateFalse value, 276

TristateTrue value, 276

True value, 647

Trust Access to Visual Basic Project option, 61, 183

Trust all installed add-ins and templates option, 183

Trusted Connection keyword, 653

two-dimensional (nested) data field, 95

txtTo box, 556

Type command, 90

Type property, 272-73, 302, 468, 469, 561, 668

Type Public keyword, 91

TypeName function, 137, 166, 246, 368

TypeName test, 316

TypeName(variable), 96