How to: Move Worksheets Within Workbooks

Applies to
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type Document-level projects Application-level projects Microsoft Office version Excel 2003 Excel 2007 For more information, see Features Available by Application and Project Type.

You can programmatically change the position of worksheets relative to other worksheets in a workbook. If you do not specify a location for the moved sheet, Excel creates a new workbook to contain it.

To move a worksheet in a document-level customization

• Assign the total number of sheets in the workbook to a variable and then move the first worksheet so that it becomes the last one.

  Dim totalSheets As Integer = Application.ActiveWorkbook.Sheets.Count
  Globals.Sheet1.Move(After:=Globals.ThisWorkbook.Sheets(totalSheets))
  

  int totalSheets = this.Application.ActiveWorkbook.Sheets.Count;
  Globals.Sheet1.Move(missing, Globals.ThisWorkbook.Sheets[totalSheets]);
  

To move a worksheet in an application-level add-in

• Assign the total number of sheets in the workbook to a variable and then move the first worksheet so that it becomes the last one.

  Dim totalSheets As Integer = Application.ActiveWorkbook.Sheets.Count
  CType(Application.ActiveSheet, Excel.Worksheet).Move(After:=Application.Worksheets(totalSheets))
  

  int totalSheets = this.Application.ActiveWorkbook.Sheets.Count;
  ((Excel.Worksheet)Application.ActiveSheet).Move(missing, 
      this.Application.Worksheets[totalSheets]);
  

See Also

Tasks

How to: Hide Worksheets

How to: Delete Worksheets from Workbooks

How to: Protect Worksheets

Concepts

Working with Worksheets

Global Access to Objects in Visual Studio Tools for Office Projects

Reference

Copy

Change History

Date	History	Reason
July 2008	Added a code example that can be used in an application-level add-in.	Customer feedback.