How to control the Sheet tab position

B

Bobby

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"
 
B

Bobby

Bobby said:
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"
Click to expand...
Bobby, this is how you do it!
Sheets("TMP").Select
Sheets("TMP").Move Before:=Sheets(1)
or
Sheets("TMP").Move After:=Sheets(1)
 
G

Gord Dibben

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

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible after creating a new sheet to insert code in it? 9
Add sheet and name it unless it already exists 12
If named sheet exists then delete it 9
Long VBA Code - Can it be reduced 11
sheet tabs bar position - may i change? 2
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
For Each WS .... 2
Need help modifying a macro 1

Top