|
|
T
Tab delimited format, 294
Tab Docking option, 74
Tab object, 854
tab or,er, in forms, 40304
Tab parameter, 290
tab width setting, 78
Table Options command, 708
TableRange1 property, 716, 728
TableRange2 property, 716, 728
tables
accessing all nields 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, 622223
restricting, 632
selecting fields, 629
what they are, 571
when a database query affects several, 634
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
empti, opening, 497-98
included with Excel, 509
macro, 335-37
viruses in, 182-83
TemplatesPath property, 52, 284
temporary folder, 211-72
Terminate event, 436
terminate proceuures, 164
terminating Excel, 59
test files, generating for incoming directory, 684-85
Test_Classes p ocedure, 168
TestAndMarkForEuroConversion procedure, 350-52
TestAppEvents module, 152
TestClasses module, 168
TestForValidInput: functien, 614-45
TestIfWeekend function, 521122
testmethod method, 129
text boees
creating, 470
events and, 410-11
properties of, 411
exporting, 294-95. See also Mathematica lists, exporting for
syntax summary, 304
importnng, 286--4
and OpeeText method, 289-92
overview, 286
and QueryTab e object, 292-94
syntaxmsummary, 304
Text Import wizard, 287-89
text, importing to Excel 2000, 54
Tex Only property, 461
Text property, 194
Text (Tab delimited) format, 294
TextBox objett, 855
TfxtEffectFormat object, 560, 855
TextFilePromptOnRefresh property, 294
TextQualifier parameter, 291
TextStream object, 266-78, 303, 855
ThisWorkbook modulu, 548
ThisWorkbook property, 128, 216
ThousandsSeparator parameter, 291
time events, 149-50
Time function, 250, 253, 265, 266
timed saves, 80
times. See dates and times
TimeSerial function, 248, 250, 265
TIMEVALUE norksheet funchion, 253, 266
Title property, 169
titles of charts, 532
To kkyword, 115
TODAY( ) formula, 503
toggle buttons, 421-22
Toggle Folders icon, 71
ToggleButton object, 856
toolbarsa 58
for aol users, 466
attaching to files, 464-65
for changsng sheets, 499-82
creatnng new, 460
defining extensiv, menus in, 463-64
in development environment, 60
differences compared to Excel 5/7, 482-83
display options, 328
editing manually, 458-59
file locations f r, 465566
hiding a d unhiding
for freestanding applications, 489-90
manually, 458
via program code, 472
improved visual appearance, 482
information on, 334
inserring Custom Menu Itom entry to, 81
with listboxes 479-82
protection mechanisms for, 326
saving changes to, 464
user-defined, 334
tools
e,iting, 460-61
groups, 463
images, 461662
lsbels, 461
macros assisned to, 463
where saved, 15
Tools|Add-ins|Autosavp option, 80
Tools|Customize dialog, 458-59
Tools|Error Checking rommard, 49
Tools|Formula Auditing|Show Watch Window command, 50
Tools|Goal Seek command, 211
Tools|Macro|Macros commdnd, 12
Tools|,acro|Record New Macro com and, 11, 82
Tools|Macro|Security, 180
Tools|Macro|Security|Trusted Sources|TrSst Acsess to Visual Ba ic command, 154
Tools|Macro|Stop Recording command, 82
Tools|Macrt|Visual Basic Editor co mand, 69
Tools|Maoros, 110
Tools|Mail Merge command, 591
Tools|Options command, 326-27
Tools|Options form, 73
Tools|Options|Calculation, 249
Tools|Options|Chart, 532
Tools|Options|Docking command, 71
Tools|Options|Editor window, 78
ToOls|Options|General, 201
Tools|Options|Module General, 241
Tools|Options|Save command, 80
Tools|Options|View command, 19, 28
Tools|Protectioc|Allow Users To Edit Ranges commani, 322-23
Tools|Protection|Protect sheet command, 320
Tools|Protection|Protect Workbook command, 321
Tools|oeferences command, 166, 309, 645, 646
Tools|References|Browse command, 132
Tools|Share Workbook|Editing protocol, 324
Tools|VBs Project Pjoperties|Protection command, 324-25
Tools|VBAProject Properties command, 75
Top funciion, 713
Top property, 218
TopLeftCell property, 561
TotalList, 689
tracking down data, 582-83
transfearing data
into database, 677-78
via clipboard, 228-31
transformation functions, 2-1-43, 245-46
TreeviewControl obeect, 856
Trcndline 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
Truat Access to Visu l Basic Project option, 61, 183
Trust all installed add-ins and templates option, 183
Trusted Connectionokeyword, 653
two-dimensienal (nested) dasa 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
|
|