Re: FW: $$Excel-Macros$$ Need Help - To rename the sheet

2012-06-07 Thread Mangesh Dayne
Hi Rajan, Its working fine now. Thanks again. Mangesh On Thu, Jun 7, 2012 at 8:39 PM, Rajan_Verma wrote: > I think I misunderstood your question , you can use this macro : > > ** ** > > Private Sub Workbook_Open() > > Dim wksSheet As Worksheet > > For Each wksSheet In Me.Wo

FW: $$Excel-Macros$$ Need Help - To rename the sheet

2012-06-07 Thread Rajan_Verma
I think I misunderstood your question , you can use this macro : Private Sub Workbook_Open() Dim wksSheet As Worksheet For Each wksSheet In Me.Worksheets If wksSheet.Name = "Result" Then wksSheet.Copy , ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)