VBA to order sheet tab according to months...

[pedie]

Is there a way for VBA to order sheet tab according to months...

My sheet names are in month name as "Jan","Feb","Mar" and so on till "dec"...

I always want sheet tab to stay in month order...

Thanks for helping

 

[VoG]

Hi Pedie. Try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=72

 

[Andrew Poulsom]

Maybe this will help you:

http://www.cpearson.com/Excel/sortws.aspx

 

[capparfrank]

Sub forceMonthOrder()
    Sheets("Jan").Move Before:=Sheets("Feb")
    Sheets("Feb").Move Before:=Sheets("Mar")
    Sheets("Mar").Move Before:=Sheets("Apr")
    Sheets("Apr").Move Before:=Sheets("May")
    Sheets("May").Move Before:=Sheets("Jun")
    Sheets("Jun").Move Before:=Sheets("Jul")
    Sheets("Jul").Move Before:=Sheets("Aug")
    Sheets("Aug").Move Before:=Sheets("Sep")
    Sheets("Sep").Move Before:=Sheets("Oct")
    Sheets("Oct").Move Before:=Sheets("Nov")
    Sheets("Nov").Move Before:=Sheets("Dec")
    
End Sub

 

[pedie]

Thanks everyone for showing me the way....
Works now.