I just upgraded from excel 2010 to 2016 and now I am getting a debug error when I start the macro at the line 'Workbooks("Live Trade Monitor - IB.xlsm").Worksheets("Live Trades").Select' only if my cursor is selecting a cell in a separate excel workbook that I have open. If my cursor is selecting a cell in the active workbook in which this macro runs then the code runs correctly. If someone can help me correct this error I would appreciate it. Thanks


The error that I am receiving is
Run time error '1004'
Select method of worksheet class failed



Please Login or Register  to view this content.