Thread: Activate sheet in another workbook by its code name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default 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??


Reply With QuoteReply With Quote