Looking for the correct syntax to verify if workbook and worksheet are active and if so continue to process code accordingly.
Set mybook = ThisWorkbook.Sheets
Set mybook = Workbooks.Open(MyPath & MyFiles(FNum), UpdateLinks:=2)
My code runs three functions and the 1st function opens the workbook, so in different portion of the code needs to validate if the workbook is active. Note I will always have another workbook (Master) open to execute the code that opens multiple files for update 1 at a time.
How do I determine which is active workbook with multiple workbooks open?