View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Password To Run Macro?

Alt + F11 VBAProject €“ Project Properties Protection Lock Project for
Viewing (check) then enter a Password and confirm.

Is that what you want or something else?

Ryan--

--
RyGuy


"Bob Phillips" wrote:

You could create a userform with a password textbox, which has a
PasswordChar character property so that you can mask it.

--
__________________________________
HTH

Bob

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

Thanks.

G