If you have opened multiple workbooks then all those Excel workbooks are components of the workbook collection. Trick 3# Activate A Workbook By Using The Number Activated the Excel worksheet by referencing the worksheet object.Also, set the Worksheet to the worksheet object.Added a new workbook and assign it to the workbook object.In the above, I have declared 2 objects for the worksheet and workbook.After then assign the workbook to any object and choose the workbook having the VBA to execute the following procedures using the Excel macros. For this, you need to create an object for the worksheet and workbook first. Trick 2# Activate Workbook or Worksheet Using ObjectĪnother method to activate the workbook in Excel is by using the object. After that just save this file as a macro-enabled workbook.Press the F5 button from your keyboard to see the output.Copy the above code and then paste it into this opened code window.Now go to hit the Insert tab from the menu bar and insert new module.After that press the Alt+F11 button from your keyboard.Workbooks(“Book2.xls”).Sheets(“Sheet1”).Activate In order to run these macros, you need to use the RunAutoMacros method. This activates workbook method won’t execute any Auto_Activate or Auto_Deactivate macros which is attached to Excel workbook. Here expression is a variable that represents the Excel Workbook object. Then by using the following code you can select the required workbook and sheet and the n activate it using the Excel VBA.

Suppose, the name of your excel workbook which you need to activate is “Book2” and it has a sheet with the name “Sheet1”. You can use this method to activate a worksheet or workbook only if you are pretty sure about the workbook name. How To Activate Workbook In Excel? Trick 1# Workbook.Activate method If you want to activate a workbook that is not yet saved, then you need to use only the name of that workbook without suffixing the file extension.When you are using the name of the workbook make sure to use the correct file extension.Once the is workbook fetched, it will activate it. After that, it will check for that specific workbook in all the opened workbooks. Well by using the above-given code, you can easily specify the workbook name.

Register windows 10 excel