using sheet1 name

[lezawang]

Hi
I have 3 sheets and they are showing in the vba editor/project window as following:

- sheet1(hello1)
- sheet2(hello2)
- sheet3(hello3)

I am moving these sheets around using vba code and I want to make sure that sheet1 is the active one after whatever move I do. I remember once I used code name to activate sheet1(hello1), but it does not work now

Sub abc()
    Workbooks(1).Sheet1.Activate
End Sub

I am trying to avoid using worksheets("hello1")

 

[Fluff]

Do not specify the workbook.
Codenames refer to the workbook, that contains the code

 

[lezawang]

"Codenames refer to the workbook, that contains the code"
Did not know that. Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback