Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = NewSheetName
Sheets(CurrentSheet).Select
End If
Application.ScreenUpdating = True
End Sub
Paul
________
From: Manish Pansari
To: MS EXCEL AND VBA MACROS
Sent: Fri, February 19, 2010 8:32:42 AM
Subject: $$Exc
Dear Excel Masters,
I need your help. I want to insert a new worksheet through macro and
want to change that sheet name with pre-defined name in master sheet.
Whatever name i defined in mastersheet, macro will insert that
worksheet in my work book. Further, if work book have that name
worksheet t
