WorkflowTemplate Properties
The Applicationand Creatorproperties are defined at the beginning of this appendix.
Name
Returns
Description
Description
String
Read-only. Returns the description value for the workflow
template.
Document
String
Read-only. Returns the name of the document library 
Library
associated with the workflow template.
Name
Document
String
Read-only. Returns the URLof the document library where 
LibraryURL
workflow templates are stored.
Id
String
Read-only. Returns the ID of the template used to create a
workflow instance.
Name
String
Read-only. Returns the name of the WorkflowTemplate
object.
WorkflowTemplate Methods
Name
Returns
Parameters
Description
Show
Long
Displays a configuration user interface
for the specified WorkflowTemplate
object.
1078
WorkflowTemplate Properties
Pdf rotate just one page - rotate PDF page permanently in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Empower Users to Change the Rotation Angle of PDF File Page Using C#
rotate individual pages in pdf reader; how to rotate a page in pdf and save it
Pdf rotate just one page - VB.NET PDF Page Rotate Library: rotate PDF page permanently in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
PDF Document Page Rotation in Visual Basic .NET Class Application
rotate pdf pages on ipad; rotate pdf page and save
I
n
d
e
x
Index
A
AboveAverageobject,636–638,753
AboveBelowproperty,AboveAverageobject,637
Absfunction,156
absolute recording,7–8
Acceptproperty,CalloutFormatobject,680
AcceptAllChangesmethod,Workbookobject,944
Access,and ADO
connecting to Access,448–449
inserting,updating,and deleting records with plain text
SQL,452–454
overview,419–423
retrieving data using plain text queries,449–450
retrieving data using stored queries,451–452
Actionobject,638–639
ActionControlproperty,CommandBarscollection,999
Actionscollection,638–639
Activateevent
Chartobject,694
Workbookobject,951
Worksheetobject,962
Activatemethod
Chartobject,690
overview,93–94
Rangeobject,858
VBcomponentobject,987
Windowobject,933
Workbookobject,944
Worksheetobject,958
ActivateMsomethod,317
ActivateNextmethod,Windowsobject,933
ActivatePreviousmethod,Windowsobject,933
Active Office language,538
active properties,64–65
Active Server pages (ASP),532
ActiveCellproperty
Applicationobject,643
Windowscollection,930
ActiveChartobject,186
ActiveChartproperty
Applicationobject,643
Windowobject,930
Workbookscollection,937
ActiveCodePaneproperty,VBE,989
ActiveConnectionproperty
Commandobject,457
Recordsetobject,441–442,446,463
ActiveMenuBarproperty,CommandBars
collection,999
ActiveMicrosoftAppmethod,Application
object,656
ActivePaneproperty,Windowsobject,930
ActivePrinterproperty,Applicationobject,643
ActiveSheetproperty
Applicationobject,644
Windowobject,930
Workbookscollection,937
ActiveSheet.UsedRange,107,684,726,759,925
ActiveSheetViewproperty,Windowsobject,930
ActiveVBProjectproperty,VBE,989
ActiveWindowproperty
Applicationobject,644
VBE,989
ActiveWorkbookproperty,65,644
ActiveX category,496
ActiveXcontrols
CheckBoxcontrol,212
dynamic,216–219
Option Buttoncontrols,212–214
C# PDF: C# Code to Process PDF Document Page Using C#.NET PDF
Able to separate one PDF file into two PDF PDF page processing functions by just following attached C# PDF Page Processing: Rotate PDF Page - detailed guidance
rotate a pdf page; pdf rotate single page and save
C# PDF Page Move Library: re-order PDF pages in C#.net, ASP.NET
library control, developers can swap or adjust the order of all or several PDF document pages, or just change the position of certain one PDF page in an
how to rotate all pages in pdf in preview; how to rotate one pdf page
ActiveXcontrols (continued)
and running macros,13–15
Scrollbarcontrol,211
SpinButtoncontrol,211–212
ActiveX Data Objects (ADO)
Commandobject
collections,447
methods,446–447
properties,446
Connectionobject,437–441
collections,441–443
events,440–441
methods,439–440
properties,437–438
Recordsetobject,441–445
collections,445
events,445
methods,443–445
properties,441–443
SELECTStatement,432–434
Structured Query Language (SQL) overview,431–435
DELETEstatement,435
INSERTstatement,434
UPDATEstatement,434–435
using in Excel applications,447–448
using with Access,448–454
connecting to Access,448–449
inserting,updating,and deleting records with plain text
SQL,452–454
retrieving data using plain text queries,449–450
retrieving data using stored queries,451–452
using with non-standard data sources,463–468
inserting and updating records in workbooks,466–467
querying text files,467–468
querying workbooks,464–466
using with SQL Server,454–463
connecting to SQL Server,455–456
disconnected recordsets,461–463
multiple recordsets,460–461
stored procedures,456–460
ActiveX Data Objects Multidimensional (ADO MD),
522–523
ActiveX settings category,495–496
ActiveXControlproperty,SmartTagActionobject,894
AdaptiveMenuproperty,CommandBarobject,1001
AdaptiveMenusproperty,CommandBars
collection,999
Add button,15,252,405
Add Chartsmethod,Chartscollection,686
Add fieldsmethod,166
Addmethod
AllowEditRangescollection,641
CalculatedMemberscollection,678
CommandBarControlscollection,1010
CommandBarscollection,1000
CustomXMLPartscollection,1020
CustomXMLSchemaCollectionobject,1023
CustomXMLValidationErrorscollection,1024
DocumentPropertiescollection,1030
FileDialogFilterscollection,1033
FileTypescollection,1035
LinkedWindowsCollection,982
NewFileobject,1046
Permissionobject,1050
QueryTablescollection,846
Scenarioscollection,871
SearchFolderscollection,1053
SeriesCollection object,873
ServerViewableItemscollection,878
SharedWorkspaceFilescollection,1056
SharedWorkspaceFolderscollection,1057
SharedWorkspaceMemberscollection,1059
SharedWorkspaceTaskscollection,1060
Sheetscollection,892
SortFieldscollection,897
TabStops2collection,1069
UserAccessListobject,922
Validationobject,924
VBcomponentscollection,988
VBprojectscollection,992
Watchescollection,927
Workbookscollection,935
AddCalloutmethod,Shapescollection,880
AddChartmethod,177,184,187,880
AddCollectionCollectionmethod,
CustomXMLSchemacollection,1023
AddCommentmethod,Rangeobject,858
AddConnectormethod,Shapescollection,880
AddCurvemethod,Shapescollection,880
AddCustommethod,VBcomponentscollection,988
AddCustomListmethod,Applicationobject,656
AddFormControlmethod,Shapescollection,880
AddFromFilemethod
CodeModuleobject,976
Referencecollection,985
Workbook.Connectionscollection,953
AddFromGuidmethod,Referencecollection,985
AddFromStringmethod,597
AddFromStringmethod,CodeModuleobject,976
add-inclass,388,396,401,407
Add-Inobject,639
AddInobject,640,973–974
AddIndentproperty
CellFormatobject,682
Rangeobject,852
Styleobject,901
1080
ActiveX controls (continued)
Process Images in Web Image Viewer | Online Tutorials
Easy to rotate the current picture or file page through just a button click; Commonly used document types are supported, including PDF, multi-page TIFF and
pdf reverse page order; saving rotated pdf pages
VB.NET Create PDF Library SDK to convert PDF from other file
be easily integrated into many MS Visual Studio .NET applications to create PDF with just a few VB.NET: Create a New PDF Document with One Blank Page.
rotate single page in pdf reader; rotate individual pdf pages reader
AddinInstallevent,381,951
Add-ins
closing,375–376
code changes,376
creating,374–375
hiding code,374
installing,379–381
interface changes,377–379
removing from Add-ins list,381–382
saving changes,377
Add-ins category,494,498
Addinscollection,639,640
Add-ins dialog box,295–297,373,379,381,382,385,
386,395,396,398,405,575,588,598
AddInsproperty,Applicationobject,644
Add-Ins tab,319,335
AddinUninstallevent,381,951
Addin.xlamfile,379
AddItemmethod,150,216,218,1008
AdditionalXmlproperty,SignatureSetupobject,
1066
AddLabelmethod,Shapescollection,880
AddLinemethod,Shapescollection,880
AddMenuprocedure,579
AddNamespacemethod,CustomXMLPrefixMapping
collection,1022
AddNodemethod,CustomXMLPartobject,1021
AddNonVisibleSignaturemethod,SignatureSet
collection,1062
AddOLEObjectmethod,Shapescollection,880
AddPeriodsmethod,TextRange2 object,1071
AddPicturemethod,Shapescollection,880
AddPolylinemethod,Shapescollection,881
AddReplacementmethod,AutoCorrect object,666
Addressproperty,111,128,760,761,852
AddressLocalproperty,Rangeobject,852
AddShapemethod,Shapescollection,881
AddSignatureLinemethod,SignatureSet
collection,1062
AddTextboxmethod,Shapescollection,881
AddTextEffectmethod,Shapescollection,881
AddToFavoritesmethod,Workbookobject,944
AddToSearchFoldersmethod,ScopeFolder
object,1053
AddToTableparameter,166,832
AdjustColumnWidthproperty,QueryTable
object,847
Adjustmentsobject,640–641
Adjustmentsproperty
Shapeobject,881
ShapeRangeobject,887
ADO (ActiveX DataObjects)
Commandobject
collections,447
methods,446–447
properties,446
Connectionobject,437–441
collections,441–443
events,440–441
methods,439–440
properties,437–438
Recordsetobject,441–445
collections,445
events,445
methods,443–445
properties,441–443
SELECTStatement,432–434
Structured Query Language (SQL) overview,431–435
DELETEstatement,435
INSERTstatement,434
UPDATEstatement,434–435
using in Excel applications,447–448
using with Access,448–454
connecting to Access,448–449
inserting,updating,and deleting records with plain text
SQL,452–454
retrieving data using plain text queries,449–450
retrieving data using stored queries,451–452
using with non-standard data sources,463–468
inserting and updating records in workbooks,466–467
querying text files,467–468
querying workbooks,464–466
using with SQL Server,454–463
connecting to SQL Server,455–456
disconnected recordsets,461–463
multiple recordsets,460–461
stored procedures,456–460
ADO MD (ActiveX DataObjects Multidimensional),522–523
ADOobject library,419,448
ADOobject model,436
ADORecordsetobject,179
AdParamInputparameter,446
AdParamInputOutputparameter,446
AdParamOutputparameter,446
AdParamReturnvalue parameter,446
AdStateConnectingobject,438
Advanced button,128,157,555
Advanced Filter,128,141,142,156–160,559
AdvancedFiltermethod,158,559–560,858
ADVAPI32.DLLfile,602
Afterparameter,686
AfterCalculateevent,Applicationobject,661
AfterRefreshevent,528,851
1081
AfterRefresh event
I
n
d
e
x
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
functions, including extracting one or more page(s) from PDF document. To utilize the PDF page(s) extraction function in VB.NET application, you just need to
rotate one page in pdf; how to rotate page in pdf and save
VB Imaging - VB MSI Plessey Barcode Tutorial
Resolution = 96 'set rotation barcode.Rotate = Rotate.Rotate0 barcode 100F, 100F)) docx.Save("C:\\Sample_Barcode.pdf"). Below is just an example of generating an
pdf rotate single page reader; rotate individual pages in pdf
AfterXMLExportevent,Workbookobject,951
AfterXMLImportevent,Workbookobject,951
AlertBeforeOverwritingproperty,Application
object,644
AlertStyleproperty,Validationobject,923
Alignmethod,ShapeRangeobject,889
Alignmentproperty
ParagraphFormat2object,1048
TextEffectFormatobject,907
TickLabelsobject,914
Allcapsproperty,Font2object,1035
AllowCommentsproperty,SignatureSetupobject,1066
AllowEditproperty
Rangeobject,852
UserAccesscollection,921
AllowEditRangeobject,641,642,921,922
AllowEditRangescollection,641
AllowMultiSelectproperty,237,1032
AllowPNGproperty,WebOptionsobject,928
AlternativeTextproperty
Shapeobject,881
ShapeRangeobject,887
AltStartupPathproperty,Applicationobject,644
AlwayUseClearTypeproperty,Applicationobject,644
Analysis Services,508,509,512,514–518,520,522,523
AND operator,157
Angleproperty,CalloutFormatobject,680
AnswerWizardproperty,Applicationobject,644
API,Windowsobject. SeeWindows API
APIfunctions,595,602,605–607,609,611,615,
619,620,634
Appearanceparameter,691,706,708,794,796
AppendChildNodesmethod,CustomXMLNode
object,1018
AppendChildSubtreemethod,CustomXMLNode
object,1018
AppendOnImportproperty,XmlMapobject,968
AppExcelobject,643
Application add-ins,494
Applicationevents,trapping,363,365
Applicationmethod,63
Applicationobject
active properties,64–65
Callerproperty,74–75
display alerts,65
Evaluatemethod,66–68
events,661–663
example,664
globals,63–64
InputBoxfunction,68–69
methods,656–661
OnKeymethod,72–73
OnTimemethod,71–72
properties,63,64,643–656
screen updating,66
SendKeysmethod,70–71
StatusBarproperty,70
worksheetfunctions,73–74
Applicationproperty,635,995,996
Application window,373
Application.Caller,75,133,215,333
Applications Extensibility library,571
Application.StatusBar,70,288,323,324,326,
329,339,340
Application.VBEExcelproperty,972
AppliesToproperty
AboveAverageobject,637
Top10object,915
UniqueValuesobject,919
Applymethod
Shapeobject,884
ShapeRangeobject,890
Sortobject,143,897
ApplyChartTemplatemethod,Chartobject,690
ApplyDataLabelsmethod
Chartobject,690
Seriesobject,875
ApplyFiltermethod,AutoFilterobject,668
ApplyLayoutmethod,184,690
ApplyNamesmethod,Rangeobject,858
ApplyOutlineStylesmethod,Rangeobject,858
ApplyPictToEndproperty,Seriesobject,873
ApplyPictToSidesproperty,Seriesobject,873
ApplyPolicymethod,Permissionobject,1050
ApplyThememethod,Workbookobject,944
Appointment itemobject,413
ArabicModesproperty,SpellingOptions
collection,900
ARangeobject,93
ArbitraryXMLSupportAvailableproperty,
Applicationobject,644
Areas,8,113–115,247,313,501,537,652,664,665,
692,754,827,852,1054
Areascollection,113–114,664–665
Areasproperty,Rangeobject,852
Arg1,202,203,366,659–661,692,694,695,738,864
Arg2,202–204,366,659–661,692,694,695,738,864
ArRangemethod,Windowsobject,930
Arrayfunction,56,87,109,167,216,279
arrays,55–58
converting charts to use,193,194
defining chart series with,190–193
dynamic,58,120,279
multi-dimensional arrays,57
storing,130–131
Asian language,143
1082
AfterXMLExport event, Workbook object
VB.NET TIFF: Rotate TIFF Page by Using RaterEdge .NET TIFF
specific formats are: JPEG, PNG, GIF, BMP, PDF, Word (Docx the target TIFF page(s) accurately and quickly; Rotate single or TIFF page(s) at one time just as you
permanently rotate pdf pages; pdf reverse page order preview
C# Imaging - C# MSI Plessey Barcode Tutorial
96;// set resolution barcode.Rotate = Rotate.Rotate0;// set 100F, 100F)); docx.Save(outputDirectory + "Sample_Barcode.pdf"); }. Below is just an example of
rotate pdf pages and save; save pdf after rotating pages
AskToUpdateLinksproperty,Applicationobject,644
ASP (Active Server pages),532
AssignedToproperty
SharedWorkspaceTaskobject,1061
WorkflowTaskobject,1077
Assistanceproperty,Applicationobject,644
Assistantproperty,Applicationobject,644
attributes,XML,242–243
Attributesproperty,CustomXMLNodeobject,1017
Auditing add-in,295,313
Auditing group,295–297,301
Auditing tab,296,304
Auditing.xlamfile,296
Auditing.xlamworkbook,303
Authenticatemethod,EncryptionProvider
object,1031
Autopageparameter,836
AutoAttachproperty,CalloutFormatobject,680
AutoCompletefeature,648
AutoCompletemethod,Rangeobject,858
AutoCorrectfeatures,665
AutoCorrectobject,665–667
AutoCorrectproperty,Applicationobject,644
AutoExpandproperty,AutoCorrectobject,665
AutoFillmethod,Rangeobject,858
AutoFillFormulasInListsproperty,AutoCorrect
object,665
AutoFilter dialog box,148
AutoFilter drop-downs,338
AutoFilterfeature
adding combo boxes,149–153
date format problems,151–152
getting exact date,152–153
copying visible rows,153–154
Date Custom Filter,148–149
Filterobject,148
finding visible rows,154–156
AutoFiltermethod,147,148,151,152,559,667,859
AutoFilterobject,143,147–148,667–669,746
AutoFilter operation,338
AutoFilterproperty,Worksheetobject,955
AutoFilterDataGroupingproperty,Windows
object,930
AutoFilterModeproperty,Worksheetobject,955
AutoFitmethod,Rangeobject,859
AutoFormatAsYouTypeReplaceHyperlinksproperty,
Applicationobject,644
AutoLengthproperty,CalloutFormatobject,680
AutoMarginsproperty,TextFrameobject,908
AutomaticLengthmethod,CalloutFormatobject,681
automation,161,253,265,383–391,393–399,401,
403,405,407,409,411,412,415–419,611,643,
644,792
Automation Add-Ins. See also COM Add-in Designer
IDTExtensibility2 interface,388–394
registering with Excel,385–386
in Registry,385–386
through Excel user interface,385
using VBA,385
using,386–387
in VBA,387
in worksheet,386–387
Automation add-ins dialog box,385,395
Automation button,385
AutomationSecurityAutomationSecurityproperty,
Applicationobject,644
AutoNumber field,452
AutoOutlinemethod,Rangeobject,859
AutoPercentEntryproperty,Applicationobject,644
AutoRecoverobject,669–670
AutoRecoveroption,645,670
AutoRecoverproperty,Applicationobject,645
AutoRecover setting,669
AutoRepublishproperty,PublishObjectobject,845
AutorotateNumbersproperty,Font2 object,1035
AutoScaleFontproperty
AxisTitleobject,674
ChartAreaobject,697
TickLabelsobject,914
AutoScalingproperty,Chartobject,687
AutoShapeTypeproperty
Shapeobject,881
ShapeRangeobject,887
AutoSizeproperty,TextFrameobject2object,909
AutoUpdateFrequencyproperty,Workbookobject,937
AutoUpdateSaveChangesproperty,Workbook
object,937
Axesmethod,Chartobject,690
Axisobject,670–674,690,738,756,913
AxisGroupproperty
Axisobject,671
Seriesobject,873
AxisTitleobject,674–675
AxisTitleproperty,Axisobject,671
AZ button,142
B
BackColorproperty,698,830
Background ODBC query,786
Background OLEDB query,789
background query,474,512,936
Background query option,512
BackgroundCheckingproperty,743
BackgroundQueryargument,475
BackgroundQueryproperty,QueryTableobject,847
1083
BackgroundQuery property, QueryTable object
I
n
d
e
x
VB.NET Word: How to Process MS Word in VB.NET Library in .NET
How to Rotate, Merge Word Documents Within VB.NET of the web page, here we just describe each Word powerful & profession imaging controls, PDF document, image
pdf expert rotate page; how to rotate one page in pdf document
C# Image Convert: How to Convert MS PowerPoint to Jpeg, Png, Bmp
RasterEdge.XDoc.PDF.dll. The last one is for rendering PowerPoint file to raster image Gif. This demo code just converts PowerPoint first page to Gif image.
rotate pages in pdf expert; save pdf rotate pages
BackgroundStyleproperty
Shapeobject,881
ShapeRangeobject,887
BackWallproperty,Chartobject,687
Backwardparameter,917
Backwardproperty,Trendlineobject,918
Backward2property,Trendlineobject,918
BarShapeproperty
Chartobject,687
Seriesobject,873
BaselineAlignmentproperty,ParagraphFormat2
object,1048
BaselineOffsetproperty,Font2object,1035
BaseNameproperty,CustomXMLNodeobject,1017
BaseUnitproperty,Axisobject,671
BaseUnitIsAutoproperty,Axisobject,671
BasicCodeparameter,660
Before double click,202
Beforeparameter,686,758
BeforeCloseevent,16,206,207,338,351,377,951
BeforeDoubleClickevent,215,366,367,694,962
BeforePrintevent,207,363,951
BeforeRefreshevent,528,851
BeforeRightClickevent,200,217,343,695,962
BeforeSaveevent,16,951
BeforeXMLExportevent,Workbookobject,951
BeforeXMLImportevent,Workbookobject,952
BeginGroupproperty
CommandBarButtonobject,1003
CommandBarComboBoxobject,1006
CommandBarControlobject,1011
CommandBarPopupobject,1013
BevelBottomDepthproperty,ThreeDFormatobject,911
BevelBottomInsetproperty,ThreeDFormatobject,911
BevelBottomTypeproperty,ThreeDFormatobject,911
BevelTopDepthproperty,ThreeDFormatobject,911
BevelTopInsetproperty,ThreeDFormatobject,911
BevelTopTypeproperty,ThreeDFormatobject,911
BlackWhiteModeproperty
Shapeobject,881
ShapeRangeobject,887
blockIfstructure,48–49
BlockPreviewproperty,ServerPolicyobject,1050
BlogPictureProviderPropertiesmethod,
IBlogPictureExtensibilityobject,1041
BlogProviderPropertiesmethod,
IBlogExtensibilityobject,1039
Blurproperty,ShadowFormatobject,879
BOFproperty,Recordsetobject,442
Boldproperty,Font2object,1035
bookmark,426,427
BOOLCdata type,604
Borderobject,676–677
Borderproperty
Axisobject,671
AxisTitleobject,674
CalloutFormatobject,680
SeriesLinesobject,877
Trendlineobject,918
BorderAroundmethod,Rangeobject,859
Bordersproperty
AboveAverageobject,637
CellFormatobject,682
Rangeobject,853
Styleobject,901
TableStyleElementobject,906
Top10object,915
UniqueValuesobject,919
BottomRightCellproperty,Shapeobject,881
BoundColumnproperty,279
BoundHeightproperty,TextRange2object,1070
BoundLeftproperty,TextRange2object,1070
BoundTopproperty,TextRange2object,1070
BoundWidthproperty,TextRange2object,1070
<box ...> contents </box> containercontrol,301
boxelement,298
boxStyleattribute,301
Break key,5
BreakLinkmethod,Workbookobject,944
BreakSideBySidemethod,Windowsobject,930
Browse button,379,406,492
BubbleSizesproperty,Seriesobject,874
BuildFreeformmethod,Shapescollection,881
Buildproperty,Applicationobject,645
BuildFileNameproperty,VBprojectobject,990
built-in command bars,322–325
BuiltInproperty
CommandBarobject,1001
CommandBarButtonobject,1003
CommandBarComboBoxobject,1006
CommandBarControlobject,1011
CommandBarPopupobject,1013
CustomXMLPartobject,1021
Referenceobject,984
Styleobject,901
TableStyleobject,905
built-in shortcut menus,338
BuiltinDocumentPropertiesproperty,Workbook
object,938
BuiltInFaceproperty,CommandBarButtonobject,1003
Bulletproperty,ParagraphFormat2object,1048
BulletFormat2object,996–997
bUseDATEfunction,542
BUseDATEfunction,543
<button .../>control type,299
Buttonparameter,695
1084
BackgroundStyle property
<buttonGroup ...> contents </buttonGroup>
containercontrol,301
ButtonNameproperty,FileDialogobject,1032
bWinToDatefunction,566–567
bWinToNumfunction,565–566
ByRefparameter,303
BYTE* Cdata type,604
BYTECdata type,604
C
Ccontrolevents,368
CcontrolEventsclass module,369
CalcForproperty
AboveAverageobject,637
Top10object,915
Calculateevent
Chartobject,695
Worksheetobject,962
Calculatemethod
Applicationobject,656
Rangeobject,859
Worksheetobject,958
CalculateBeforeSaveproperty,Application
object,645
CalculatedFieldscollection,170–171,677,812
CalculatedItemscollection,176,678,822–823
CalculatedMemberobject,678–679
CalculatedMemberscollection,678,679–680
CalculateFullmethod,Applicationobject,656
CalculateFullRebuildmethod,Application
object,657
CalculateUnitAsyncQueriesDonemethod,
Applicationobject,657
Calculationproperty,645
CalculationDoneevent,Applicationobject,661
CalculationInterruptKeyproperty,Application
object,645
CalculationStateproperty,Applicationobject,645
CalculationVersionproperty
Applicationobject,645
Workbooksobject,938
Callstatement,36,38
Callerproperty,74–75,134,210,645
Calloutproperty
Shapeobject,882
ShapeRangeobject,887
CalloutFormatobject,680–682
CanAddSignatureLine property,SignatureSet collection,
1062
Cancelparameter,200,661,663,694,695,952
Cancelproperty,281
CancelRefresh method,QueryTableobject,851
CanCheckInmethod,Workbookobject,944
CanCheckOutmethod,Workbookobject,935
CanPlaySoundsproperty,Applicationobject,645
CanRecordSoundsproperty,Applicationobject,645
CanSetupproperty,Signatureobject,1062
CapitalizeNamesOfDays property,AutoCorrect
object,666
CAppevents,363–365
Capsproperty,Font2object,1035
Captionproperty
Actionobject,638
Applicationobject,645
AxisTitleobject,674
and built-in command bars,324
Charactersobject,684
CommandBarButtonobject,1003
CommandBarComboBoxobject,1006
CommandBarControlobject,1011
CommandBarPopupobject,1013
and new menus,332
and pop-up menus,341
and user form creation,275,276
and UserFormcontrols,369
Windowobject,930,992
Catalogobject,455–458,517–520,522,523
CategoryNamesproperty,Axisobject,671
CategoryTypeproperty,Axisobject,671
CBoolfunction,542
CBytefunction,541
CChartevents,367
CCurfunction,541
CDatefunction,541
CDblfunction,541
CDecfunction,541
Cell command,340–342
Cell command bar,340–342
Cellformatobject,682–684
Cell shortcut menu,342,344
Cell1 parameter,852
Cell2 parameter,852
CellDragAndDropproperty,Applicationobject,645
CellFormatobject,682–684
Cellsproperty,51,97–101,102,123,133,175,645,
853,955
CEmployeeclass module,357
CentimetersToPointsmethod,Application
object,657
CertificateVerificationResultsproperty,
SignatureInfoobject,1063
CFormChangerclass,624–625
CFormResizerclass,627,628–634
CFreezeFormclass,618,619
Chain Pivotitemobject,823
1085
Chain Pivot item object
I
n
d
e
x
chain reaction,201
Changeevent,200,201,206,209,211,237,284,286,
287,576,962,1009
ChangeCasemethod,TextRange2object,1071
ChangeFileAccessmethod,Workbookobject,944
ChangeHistoryDurationproperty,Workbook
object,938
ChangeLinkmethod,Workbookobject,944
ChangePasswordmethod,642,922
ChangeScenariomethods,Scenarioobject,872
ChangingCellsproperty,Scenarioobject,871
Char Cdata type,604
char FAR * Cdata type,604
char huge * Cdata type,604
char NEAR * Cdata type,604
Characterproperty,BulletFormat2object,996
Charactersmethod,TextFrameobject,909
Charactersobject,684–685
Characters property
AxisTitleobject,674
Rangeobject,853
TextRange2object,1070
chartevents,199,202–204,355,365,694,695
chart labels,181,195–196,690
Chartobject
and embedded charts,185–190
events,694–695
example,696
methods,690–694,707–708
properties,687–690,706–707
Chartproperty
Shapeobject,882
ShapeRangeobject,887
chart series with arrays,defining,190
chart sheet,85,90,95,181,184,186,196,199,422,
423,692,704,710,903
Chart title,182,186,190,193,674,696,709,710
Chart tools,313
Charttypeproperty,184,192
ChartAreaobject,696–697,838
ChartAreaproperty,Chartobject,687
ChartColorFormatobject,698
ChartData sub procedure,421,422
ChartFillFormatobject,698–700
ChartFormatobject,700–701
ChartGroupobject,691,701–704,740,758,824,
839,877,920
ChartGroupscollection,701,702,704
ChartGroupsmethod,Chartobject,691
Chartobjectcollection,83,177,181,187,704,
705,708
ChartObjectobject,706–708
ChartObjectscollection,196,704–706,708
ChartObjectsmethod
Chartobject,691
Worksheetobject,958
charts
chart labels,195–196
chart sheets
adding using VBA code,184–185
recorded macro,184
controls on,220–221
converting to use arrays,193
defining chart series with arrays,190–193
determining ranges used in,194–195
editing data series in,181,187–190
embedded,185–187
adding using VBA code,186–187
using macro recorder,186
Chartscollection,83,181,184,196,685,
686–687,696,704
Chartsproperty
Applicationobject,645
Workbookobject,938
ChartStyleproperty,Chartobject,687
ChartTitlemethod,710
ChartTitleobject,184–187,708–710
ChartTitleproperty,Chartobject,687
ChartTypeproperty
Chartobject,687
Seriesobject,874
ChartViewobject,710
ChartWizardmethod,Chartobject,691
ChDrivestatement,60
CheckAbortmethod,Applicationobject,657
<checkbox .../>control type,299
CheckBoxcontrol,212,276
CheckboxStateproperty,SmartTagActionobject,894
CheckCompatibilityproperty,Workbookobject,938
CheckInmethod,Workbookobject,944
CheckOutmethod,Workbookobject,936
CheckSpellingmethod
Applicationobject,657
Chartobject,691
Rangeobject,859
Worksheetobject,958
Childproperty
Shapeobject,882
ShapeRangeobject,888
ChildNodesproperty,CustomXMLNodeobject,1017
CIntfunction,189,541
CircularReferenceproperty,Worksheetobject,955
ClassModulecollection,360–363
class modules
collection of userformcontrols,368–370
creatingcollections,359–363
1086
chain reaction
creating objects,356–357
embedded chartevents,365–367
encapsulation,363
property procedures,357–359
referencingclasses across projects,370–371
trapping Applicationevents,363–365
wrapping API calls in,611–616
class_Initializeevent,576,577
class_Initializeprocedure,579,582
class_Terminateevent,577
classes,606–609
classReferences.xlsm,370,371
classUserFormcontrols.xlsm,370,371
Clearmethod
CellFormatobject,683
ChartAreaobject,697
CommandBarComboBoxobject,1009
FileDialogFilterscollection,1033
Rangeobject,859
SortFieldscollection,897
TableStyleElementobject,906
TabStop2object,1069
XPathobject,970
ClearArrowsmethod,Worksheetobject,958
ClearCirclesmethod,Worksheetobject,958
ClearCommentsmethod,Rangeobject,859
ClearContentsmethod
ChartAreaobject,697
Rangeobject,859
ClearDefaultContextmethod,IAssistance
object,1038
ClearFormatsmethod
ChartAreaobject,697
Rangeobject,859
Seriesobject,876
Trendlineobject,918
Wallsobject,926
ClearNotesmethod,Rangeobject,859
ClearOutlinemethod,Rangeobject,859
ClearSettingsmethod,XmlDataBindingobject,967
ClearToMatchStylemethod,Chartobject,691
Clickevent,153–155,157,209,210,212,217,218,
219,277,281,286,378,398,399,400,550,
576–578,594,597,619,980
Clickevent procedure,157,210,212,219
ClipboardFormatsproperty,Applicationobject,646
CLngfunction,541
CloneSessionmethod,EncryptionProvider
object,1031
Close button,281–282,596,624
Closemethod
Connectionobject,440
Recordsetobject,444
Windowobject,933,993
Workbookobject,82,83,936,944
CloseModeparameter,282
CLSIDproperty,Add-In,639
CMenuHandlerclass,577,580,589,594
code,hiding,363
code modules,VBE,9–10
Code Window popup menu,580,589
CodeModuleobject,574,974–978
CodeModule property
CodePaneobject,978
VBcomponentobject,987
CodeNameproperty
Chartobject,687
and VBComponent,573
Workbookobject,938
Worksheetobject,955
CodePaneobject,574,978–980
CodePaneproperty,CodeModuleobject,975
CodePanesproperty,VBE,989
CodePaneViewproperty,CodePaneobject,978
collectionmethods,636
Collectionobject,359,741
collection properties,635
collections,22–23
color index,51,204,749
Colorobject,713,728,749
Colorproperty
Borderobject,677
Borderscollection,676
GlowFormatobject,1037
GradientStopobject,1038
Tabobject,903
ColorFormatobject,710–711
ColorIndexproperty
Borderobject,677
Borderscollection,676
Interiorobject,26
Tabobject,903
Colorsmethod,ThemeColorsSchemeobject,1073
Colorsproperty,Workbookobject,938
ColorScaleobject,711–713,749
ColorScaleCriteriacollection,713
ColorScaleCriteriaobject,711,712
ColorStopobject,714
ColorStopscollection,714
column field,164,818
Columnobject,113
Columnproperty
Rangeobject,853
TextFrame2object,909
column width,24,250,279,483,683,702,853,857,902
ColumnCountproperty,279
1087
ColumnCount property
I
n
d
e
x
Documents you may be interested
Documents you may be interested