Thread: Activate sheet in another workbook by its code name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andym Andym is offline
external usenet poster
  
Posts: 35
Default 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??
Reply With QuoteReply With Quote