Excel - Pasting a Graphic to Multiple Worksheets

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Positioning a Graphic in a Macro

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Using the Camera in VBA

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel Deleting Unwanted Styles

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Printing Workbook Properties

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Discovering Dependent Workbooks

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Using a Single Password for Multiple Workbooks

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Noting the Workbook Creation Date

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Noting When a Workbook was Changed

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Merging Many Workbooks

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

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

Excel - Discovering Dependent Workbooks

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London