Thread
:
Copy hidden worksheet
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Copy hidden worksheet
Sub AddNewSheet()
Worksheets("TEMPLATE").Copy After:=Worksheets(1)
Worksheets(2).Visible = xlSheetVisible
Worksheets(2).Activate
End Sub
--
Regards,
Nigel
"Porky79" wrote in message
...
Ah I see - Almost there. Copies and creates visable worksheet, but for
some reason then selects the next worksheet as the 'current' or
'active' worksheet. I want the copied sheet to be the active sheet to
prevent any data being incorrectly entered.
Thanks so much for your time
Paul
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]