Vba Worksheet Activate Vs Select Selected worksheet one or more worksheets that have been selected within an excel window. Activate a worksheet on opening. For example to enter a formula in cell d6 using visual basic you do not need to select the range d6. Selected vs activated worksheet the differences. This is the sheet you would see if you looked at your excel program.