Vba code to activate a open workbook

Myprojects,Books2,3,4 as per your recommendation. It did not work.. Run-time error Subscript out of range.. You must be logged in to post a comment. View Details. Go to VBA Tutorials. Excel Resource. In this topic:. Why we need to activate a Workbook using VBA?

Activate Sheet1. Activate 'This will activate "MyProjects1. ActiveSheet ws. Sheets 1. Activate End If Next iWorkbook. Activate Next iWorkbook End Sub. Workbooks If InStr 1, iWorkbook. Workbooks 'Do the following: ' 1 Test whether the name of the workbook the loop is currently iterating through contains "Excel VBA" ' 2 If the condition is met, activate the workbook the loop is currently iterating through If InStr 1, iWorkbook.

Important: VBA code cannot be undone, so make sure to test your code on a blank workbook, or a copy of an existing workbook.

If the code doesn't do what you want, you can close the workbook without saving changes. Paste your recorded code in the Sub procedure between the Sub and End Sub lines. To do that:. You can always ask an expert in the Excel Tech Community or get support in the Answers community. To use the example below, open a new workbook. Click Save. Need more help? Steps to Activate a Workbook. Activate a Workbook by using the Number. Activate ThisWorkbook.

Check Before Activating a Workbook.