In Excel, we manually go to the sheet and click on the Sheet tab to activate or select it. However, we can use the VBA Activate Sheet function when writing code that requires linking different sheets in different formats. With the help of the “, this can be accomplished. In VBA, use the “Activate” command.