How do you get this event macro to work?

This is a macro I found online to freeze the first tab in my workbook. I am new to VBA, so please explain in details.

Please Login or Register  to view this content.

Hawkeye, it moves the selected Worksheet so it's the second tab along the bottom. Speaking of poor attempts, did you even try to read or test the code before you bashed it?

kdanilko, to make the code work you need to open the Visual Basic Editor, double click "ThisWorkbook" and put the code in there. You can then close VBE and when you select a worksheet you will notice the tab changes position.

That code is a bit messy though, you should use the following code instead:

Please Login or Register  to view this content.

Let me know if it works for you.

No, it's an event that occurs when a worksheet is activated. Sh is required, whether you use it or not is up to you.

Anyway, my point wasn't that the code was great (notice I replaced it with 1 line that does the same job). It's that it's pointless telling someone "bad code" after they've told you they're new to VBA, and they're posting to the forum specifically asking for help.

kdanilko,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

There seems to be some confusion on what role Sh plays here. Let me explain what this object variable is.

This is a Workbook level event. This event tracks the Worksheet level event SheetActivate. The object variable Sh (Sheet) is passed from the Worksheet event to the Workbook level event after the sheet is activated. Sh always points to the sheet that became the ActiveSheet in the workbook. Because it is a Worksheet object, you have access to all properties and methods of the original sheet.

Hello Hawkeye16,

The variable Sh is automatically provided to you by the event procedure. The user does not declare this variable nor is the user required to use it.

Thanks.

Maybe I explained it weird, to clarify, what I meant by 'required' is that the Sh parameter is required. As in, the event cannot fire without the Sh parameter being passed because it's required which is why I said "whether you use it or not is up to you".

you do not run it-it runs automatically when you switch between sheets.

kdanilko, once you have pasted your code it will run every time you select a sheet. Make some new sheets, and look at how the tabs reorganise whenever you select one.

Whenever you select a sheet, this code will move it so it's 2nd along the bottom. So you can access your first sheet easily, regardless of which tab you have selected.

Does it help?