Sub activatesheet (sheetname as string) 'activates sheet of specific name worksheets (sheetname).activate end sub basically you want to make use of the.activate function. Dim wkb as workbook set wkb = workbooks.open (tire.xls) ' open workbook and set reference! Activate a worksheet with vba. Select worksheet with vba code name. 100 would the following macro help you? Web activates the first window associated with the workbook. Here are some of them. Returns nothing if no sheet is active. Select worksheet by tab name. Select worksheet by index number.
This method won't run any auto_activate or auto_deactivate macros that might be attached to the workbook (use the runautomacros method to run those macros). In the real life, you can use this method in different ways. Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Web makes the current sheet the active sheet. Select worksheet by tab name. Web activates the first window associated with the workbook. This method won't run any auto_activate or auto_deactivate macros that might be attached to the workbook (use the runautomacros method to run those macros). Sub activatesheet (sheetname as string) 'activates sheet of specific name worksheets (sheetname).activate end sub basically you want to make use of the.activate function. Dim wkb as workbook set wkb = workbooks.open (tire.xls) ' open workbook and set reference! Web occurs when a workbook, worksheet, chart sheet, or embedded chart is activated. Or you can use the.select function like so:
