Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Reference > Workbook Object > Methods > Workbook.Activate Method (Excel)
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Reference
Workbook Object
Methods
Workbook.AcceptAllChanges Method (Excel)
Workbook.Activate Method (Excel)
Workbook.AddToFavorites Method (Excel)
Workbook.ApplyTheme Method (Excel)
Workbook.BreakLink Method (Excel)
Workbook.CanCheckIn Method (Excel)
Workbook.ChangeFileAccess Method (Excel)
Workbook.ChangeLink Method (Excel)
Workbook.CheckIn Method (Excel)
Workbook.CheckInWithVersion Method (Excel)
Workbook.Close Method (Excel)
Workbook.DeleteNumberFormat Method (Excel)
Workbook.EnableConnections Method (Excel)
Workbook.EndReview Method (Excel)
Workbook.ExclusiveAccess Method (Excel)
Workbook.ExportAsFixedFormat Method (Excel)
Workbook.FollowHyperlink Method (Excel)
Workbook.ForwardMailer Method (Excel)
Workbook.GetWorkflowTasks Method (Excel)
Workbook.GetWorkflowTemplates Method (Excel)
Workbook.HighlightChangesOptions Method (Excel)
Workbook.LinkInfo Method (Excel)
Workbook.LinkSources Method (Excel)
Workbook.LockServerFile Method (Excel)
Workbook.MergeWorkbook Method (Excel)
Workbook.NewWindow Method (Excel)
Workbook.OpenLinks Method (Excel)
Workbook.PivotCaches Method (Excel)
Workbook.Post Method (Excel)
Workbook.PrintOut Method (Excel)
Workbook.PrintPreview Method (Excel)
Workbook.Protect Method (Excel)
Workbook.ProtectSharing Method (Excel)
Workbook.PurgeChangeHistoryNow Method (Excel)
Workbook.RefreshAll Method (Excel)
Workbook.RejectAllChanges Method (Excel)
Workbook.ReloadAs Method (Excel)
Workbook.RemoveDocumentInformation Method (Excel)
Workbook.RemoveUser Method (Excel)
Workbook.Reply Method (Excel)
Workbook.ReplyAll Method (Excel)
Workbook.ReplyWithChanges Method (Excel)
Workbook.ResetColors Method (Excel)
Workbook.RunAutoMacros Method (Excel)
Workbook.Save Method (Excel)
Workbook.SaveAs Method (Excel)
Workbook.SaveAsXMLData Method (Excel)
Workbook.SaveCopyAs Method (Excel)
Workbook.SendFaxOverInternet Method (Excel)
Workbook.SendForReview Method (Excel)
Workbook.SendMail Method (Excel)
Workbook.SendMailer Method (Excel)
Workbook.SetLinkOnData Method (Excel)
Workbook.SetPasswordEncryptionOptions Method (Excel)
Workbook.ToggleFormsDesign Method (Excel)
Workbook.Unprotect Method (Excel)
Workbook.UnprotectSharing Method (Excel)
Workbook.UpdateFromFile Method (Excel)
Workbook.UpdateLink Method (Excel)
Workbook.WebPagePreview Method (Excel)
Workbook.XmlImport Method (Excel)
Workbook.XmlImportXml Method (Excel)
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Workbook.Activate Method (Excel)

Office 2010

Activates the first window associated with the workbook.

expression .Activate

expression A variable that represents a Workbook object.

This method won't run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros).

This example activates Book4.xls. If Book4.xls has multiple windows, the example activates the first window, Book4.xls:1.

VBA
Copy 
Workbooks("BOOK4.XLS").Activate
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.