Activate sheet in another workbook by its code name

A

AshMorK

Is it possible to activate a sheet in workbook1 by a procedure written in
workbook2 by its code name??
 
B

Bob Phillips

With Workbooks("Some Other Book.xls")
.Worksheets(CStr(.VBProject.VBComponents("TheSheetCodeName").Properties("Name"))).Activate
End With
 
A

AndyM

Workbooks("Book2").Sheets("Sheet1").Activate

This will activate the workbook as well.
 
Top