That is not too bad to do. Set up a global variable in a standard code
module. Create a userform that allows the user to enter a password. On the
text box set the Password Character to *. Now have your macros check to see
if there is a valic password in the global variable. If so then run the
macro. If not then pop us the userform and let them enter the password. Then
double check the password entered and you are good to go...

--
HTH...

Jim Thomlinson


"garyh" wrote:

Is there a way to request a password when a macro button is clicked? I
would like to 'lock' down the macros.

Thanks.

G