P105 Move Sheet Location within Workbook (command line example list)

Examples:

Command Line Example 1: Move a worksheet to before a specified sheet

Command Line Example 2: Move a worksheet to be the first sheet

 

P105 Command Line Reference:

/P#

Meaning

Extra Parameters

105

Move sheet location within workbook.

/1 = sSheetToMove (by name or by number)

/2 = sSheetBefore (by name or by number)

/3 = sSheetAfter (by name or by number)

This special process can move a worksheet within the same workbook.

Special Parameters Described in Detail

/1{sSheetToMove} Name of the sheet to Move. Required.

/2{sSheetBefore} Moved sheet will be placed before this sheet (Name or #). If sSheetBefore = "firstfirst" then it is placed as the first sheet in the workbook.

/3{sSheetAfter} Moved sheet will be placed after this sheet (Name or #). If sSheetAfter = "lastlast" then it is placed as the last sheet

Additional Notes: Only sSheetBefore, or sSheetAfter should be specified, not both. If neither the sSheetBefore, nor the sSheetAfter have been specified then the new sheet will be the last sheet.