How to control the Sheet tab position

Hi, how can I control the position of a Sheets when adding one? For
instance
always before "SHEET1".
Thank's in advance.

Sheets.Add
ActiveSheet.Name = "TMP"

Bobby wrote:
> Hi, how can I control the position of a Sheets when adding one? For
> instance
> always before "SHEET1".
> Thank's in advance.
>
> Sheets.Add
> ActiveSheet.Name = "TMP"
Bobby, this is how you do it!
Sheets("TMP").Select
Sheets("TMP").Move Before:=Sheets(1)
or
Sheets("TMP").Move After:=Sheets(1)

When adding a new sheet........

Sub SheetAdd()
Sheets.Add Before:=Sheets("Sheet1")
End Sub


Gord Dibben MS Excel MVP

On 15 Jun 2006 16:20:14 -0700, "Bobby" <[email protected]> wrote:

>Hi, how can I control the position of a Sheets when adding one? For
>instance
>always before "SHEET1".
>Thank's in advance.
>
>Sheets.Add
> ActiveSheet.Name = "TMP"