Activate sheet in another workbook by its code name
 

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

Activate sheet in another workbook by its code name
 

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


--
__________________________________
HTH

Bob

"AshMorK" wrote in message
...
Is it possible to activate a sheet in workbook1 by a procedure written in
workbook2 by its code name??

Activate sheet in another workbook by its code name
 

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

This will activate the workbook as well.

"AshMorK" wrote:

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