I have 2 workbooks open and during the course of a macro am switching between them. The macro has developed a problem where it seems to disregard the workbook.activate command when running. If I set a breakpoint at the line with the activate command and step through it, it works fine.

I have tried activating using ThisWorkbook,Worksheets().activate, Workbook(xx).activate, Windows(xx).activate. I have also tried minimizing the other window which I do not want activated, but this causes the main macro to freeze. This is only a problem at one point in my macro and it works properly elsewhere. I have 2 workbooks open and during the course of a macro am switching between them. The macro has developed a problem where it seems to disregard the workbook.activate command when running.

If I set a breakpoint at the line with the activate command and step through it, it works fine. I have tried activating using ThisWorkbook,Worksheets().activate, Workbook(xx).activate, Windows(xx).activate.

Vladimirov Equations Of Mathematical Physics Pdf here. How can the answer be improved? ActiveSheet Property [Excel 2003 VBA Language. In the active workbook or in the specified window. MsgBox 'The name of the active sheet is ' & ActiveSheet.Name.

I have also tried minimizing the other window which I do not want activated, but this causes the main macro to freeze. This is only a problem at one point in my macro and it works properly elsewhere. There is no need to 'switch' between the workbooks, just assign a reference to them, and access the methods and properties for each workbook. Dim wb1 as Workbook, wb2 as Workbook 'assuming both workbooks are already open Set wb1 = Workbooks('Name of First WB') Set wb2 = Workbooks('Name of Second WB') Also unless you really need to observe what the macro is doing during execution, there is no reason to have multiple Workbook.Activate statement. Just have one final one at the end of the macro to activate the workbook you really want to see at the end of the macro execution. I have 2 workbooks open and during the course of a macro am switching between them.

The macro has developed a problem where it seems to disregard the workbook.activate command when running. If I set a breakpoint at the line with the activate command and step through it, it works fine.

I have tried activating using ThisWorkbook,Worksheets().activate, Workbook(xx).activate, Windows(xx).activate. I have also tried minimizing the other window which I do not want activated, but this causes the main macro to freeze. This is only a problem at one point in my macro and it works properly elsewhere. There is no need to 'switch' between the workbooks, just assign a reference to them, and access the methods and properties for each workbook. Dim wb1 as Workbook, wb2 as Workbook 'assuming both workbooks are already open Set wb1 = Workbooks('Name of First WB') Set wb2 = Workbooks('Name of Second WB') Also unless you really need to observe what the macro is doing during execution, there is no reason to have multiple Workbook. Gute Alte Pc Spiele En more. Activate statement.

Just have one final one at the end of the macro to activate the workbook you really want to see at the end of the macro execution. Hi Ken, >>I have tried activating using ThisWorkbook,Worksheets().activate, Workbook(xx).activate, Windows(xx).activate. I have also tried minimizing the other window which I do not want activated, but this causes the main macro to freeze.