View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Require a password to execute a macro

Look at the property: PasswordChar of the textbox control.
Make it something like * and it will do exactly what you want.

RBS

"Rjeffay" wrote in message
...

After some searching Have found code examples to accomplish this with an
inopuit box. But the password is not hidden when entered. I believe a
user form would accomplish this, buty i am clueless as to how to write
the code for a password required which is hidden by characters such as
asteriks. Any help would be appreciated.


tia


--
Rjeffay
Posted from - http://www.officehelp.in