Changing the contents of a module

[biker boy]

Problem
I have a number (over 80) of Excel files that use an auto_run function to protect the sheets on opening. Ineed to change the password the in modules but want to use a macro to perform the task.

example

sub auto_run()
sample
end sub

function sample
active sheet.protect password:="rabbit"
end function

How can I change "rabbit" to another word

[paulw]

Pass in the password as a parameter.

Cheers,

P.