Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Primary Interop Assembly Reference
Class Library
Microsoft.Office.Interop.Excel Namespace
_Workbook Interface
_Workbook Properties
_CodeName Property
_ReadOnlyRecommended Property
AcceptLabelsInFormulas Property
AccuracyVersion Property
ActiveChart Property
ActiveSheet Property
ActiveSlicer Property
Application Property
Author Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
BuiltinDocumentProperties Property
CalculationVersion Property
ChangeHistoryDuration Property
Charts Property
CheckCompatibility Property
CodeName Property
Colors Property
CommandBars Property
Comments Property
ConflictResolution Property
Connections Property
ConnectionsDisabled Property
Container Property
ContentTypeProperties Property
CreateBackup Property
Creator Property
CustomDocumentProperties Property
CustomViews Property
CustomXMLParts Property
Date1904 Property
DefaultPivotTableStyle Property
DefaultSlicerStyle Property
DefaultTableStyle Property
DialogSheets Property
DisplayDrawingObjects Property
DisplayInkComments Property
DocumentInspectors Property
DocumentLibraryVersions Property
DoNotPromptForConvert Property
EnableAutoRecover Property
EncryptionProvider Property
EnvelopeVisible Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
Excel8CompatibilityMode Property
FileFormat Property
Final Property
ForceFullCalculation Property
FullName Property
FullNameURLEncoded Property
HasMailer Property
HasPassword Property
HasRoutingSlip Property
HasVBProject Property
HighlightChangesOnScreen Property
HTMLProject Property
IconSets Property
InactiveListBorderVisible Property
IsAddin Property
IsInplace Property
KeepChangeHistory Property
Keywords Property
ListChangesOnNewSheet Property
Mailer Property
Modules Property
MultiUserEditing Property
Name Property
Names Property
OnSave Property
OnSheetActivate Property
OnSheetDeactivate Property
Parent Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
PrecisionAsDisplayed Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
ReadOnly Property
ReadOnlyRecommended Property
RemovePersonalInformation Property
Research Property
RevisionNumber Property
Routed Property
RoutingSlip Property
Saved Property
SaveLinkValues Property
ServerPolicy Property
ServerViewableItems Property
SharedWorkspace Property
Sheets Property
ShowConflictHistory Property
ShowPivotChartActiveFields Property
ShowPivotTableFieldList Property
Signatures Property
SlicerCaches Property
SmartDocument Property
SmartTagOptions Property
Styles Property
Subject Property
Sync Property
TableStyles Property
TemplateRemoveExtData Property
Theme Property
Title Property
UpdateLinks Property
UpdateRemoteReferences Property
UserControl Property
UserStatus Property
VBASigned Property
VBProject Property
WebOptions Property
Windows Property
Worksheets Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
XmlMaps Property
XmlNamespaces Property
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

_Workbook.ActiveSheet Property

Office 2010

Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
C#
VB
Copy 
Object ActiveSheet { get; }

Property Value

Type: System.Object

If you don’t specify an object qualifier, this property returns the active sheet in the active workbook.

If a workbook appears in more than one window, the ActiveSheet property may be different in different windows.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.