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

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


--
__________________________________
HTH

Bob

"AshMorK" <(E-Mail Removed)> wrote in message
news:8A0A2846-D214-42FF-86E2-(E-Mail Removed)...
> Is it possible to activate a sheet in workbook1 by a procedure written in
> workbook2 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??