Move sheet to the very beginning?

[Maximus2500]

Hello, I am completely new to VBA and am trying to learn it.
I can't figure out how to move a named sheet to the very beginning.

I've got:

Please Login or Register  to view this content.

I've also tried this:

Please Login or Register  to view this content.

But it doesn't do it. It just keeps adding it after sheet1. Can you help? Is it possible to move it before Sheet1? I can't figure it out. I've been looking online for a while...

I know this is kiddy stuff to you. :/ Do you think you could please help?

[Logit]

See if this works (resource : https://msdn.microsoft.com/en-us/lib.../ff834742.aspx )

Please Login or Register  to view this content.

[YasserKhalil]

Try to rely on sheet index like that

Please Login or Register  to view this content.

[shg]

Or all at once:

Please Login or Register  to view this content.

[Maximus2500]

Thank you all! None of those codes worked. I'm beginning to wonder if there's something wrong with my Excel VBA?

I've tried doing it in a module and in a sheet. But literally nothing works.

I looked at that Microsoft article and this one: https://msdn.microsoft.com/en-us/lib.../ff839847.aspx

Do you guys have any advice? Do you think reinstalling Microsoft Office 2016 would help?

[Maximus2500]

Oh and sorry about the duplicate thread. There was an error with the webpage and I started over because I thought it didn't post.

[shg]

Is the workbook shared?

[Logit]

My code (Post #2) was placed into a routine module.

[Maximus2500]

Is the workbook shared?

No, it's not shared. Or not that i know of...

I really have no idea what's wrong. :/

[Maximus2500]

My code (Post #2) was placed into a routine module.

Thank you Logit! I'll try it out.

[Maximus2500]

Forgot to tell you, your code worked! Thank you!

[Logit]

Great. Glad to help.

Thanks. Please mark thread SOLVED.