Thread: If Workbook not Open Then Open It
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_8_] Tim Zych[_8_] is offline
external usenet poster
  
Posts: 18
Default If Workbook not Open Then Open It
ThisWorkbook.Activate


"scain2004 " wrote in message
...
Ok, that worked, except I need the focus to remain on the calling
workbook. How should I do that?


Workbooks("Production Job List - 040516.xls").Activate ?


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote