Macro Script

[Brandon]

I know how to record a macro . . . but how would I convert the following
Script into an Excel macro?

Option Explicit
Sub testme()
Dim wks As Worksheet
Dim myPWD As String

myPWD = "hi"
For Each wks In ActiveWorkbook.Worksheets
wks.Protect Password:=myPWD
Next wks
End Sub

 

[Dave Peterson]

I think that it's already a macro.

But you have to know how to "install" it.

you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Brandon]

thanks, but I don't see anything there that helps me understand what to do
with the script below.

 

[JE McGimpsey]

Take a look at the "use someone else's macro" section:

http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro