using sheet code name to call Activate function

[lezawang]

Hi
I have workbook which has worksheet called hello or sheet1(hello) that is how it looks like in the vba project window. The code below does not work because of

 Workbooks(1).Sheet1.Activate

but if I changed it to

 workbooks(1).worksheets("hello").Activate

it will work! Why is that? thank you very much

Sub create_ws_using_ws_collection()
    Dim x As Integer
    x = InputBox("for which book")
    Workbooks(x).Worksheets.Add after:=Sheet1
    Workbooks(1).Sheet1.Activate
End Sub

 

[Fluff]

To use the sheet codename, you do it like

Sheet1.Activate

But it only works for the workbook that contains the code.