Excel - Opening a Workbook to a Specific Worksheet

Steve wonders if it is possible to somehow configure a workbook so that it opens on the same worksheet tab each time it is opened, rather than on the worksheet tab that was displayed when the workbook was last saved. The short answer is that you can do this—provided you use a macro. (There is no way to do it without a macro.)

There are two ways you can set up your macro. First, you can use a traditional Auto_Open macro that is automatically run whenever a workbook is opened:

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London