United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Office and SharePoint development

Office client development

Office 2007

Excel 2007

Excel 2007 Developer Reference

Excel Object Model Reference

Worksheet Object

Methods

Activate Method

Calculate Method

ChartObjects Method

CheckSpelling Method

CircleInvalid Method

ClearArrows Method

ClearCircles Method

Copy Method

Delete Method

Evaluate Method

ExportAsFixedFormat Method

Move Method

OLEObjects Method

Paste Method

PasteSpecial Method

PivotTables Method

PivotTableWizard Method

PrintOut Method

PrintPreview Method

ResetAllPageBreaks Method

SaveAs Method

Scenarios Method

Select Method

SetBackgroundPicture Method

ShowAllData Method

ShowDataForm Method

Unprotect Method

XmlDataQuery Method

XmlMapQuery Method

Minimize

This topic has not yet been rated - Rate this topic

Worksheet.Activate Method

Office 2007

Makes the current sheet the active sheet.

Syntax

expression.Activate

expression A variable that represents a Worksheet object.

Remarks

Calling this method is equivalent to clicking the sheet's tab.

Example

This example activates Sheet1.

Visual Basic for Applications
`Worksheets("Sheet1").Activate`

See Also

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.