How do I input a code?

[tmleafs]

I've searched the forms and I have found a few codes that I want to use.

The first is for all capital letters. I can't seem to find it again, but I'm sure that I will sometime soon.

The second is a code that hides all rows that have a zero in a specific column.

Will these codes stay there for the life of the file or do I have to re-enter them every time I want to use it?

Thanks.

 

[tmleafs]

Sub HideRowsIfSumZero()
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Range("W4:W50")
If UCase(cell.Value) = "0" Then
cell.EntireRow.Hidden = True
End If
Next
Application.ScreenUpdating = True
End Sub

 

[VoG]

The code will remain with the file unless you delete the code.

 

[tmleafs]

This is the code that I need. How do I make it work?

 

[VoG]

Press ALT + F11 to open the Visual Basic, select Module from the Insert menu and paste the code into the white space on the right.

Press ALT + Q to close the code window, Press ALT + F8, click on the name of the macro then click the Run button.