Require a password to execute a macro

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

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

RBS

"Rjeffay" <Rjeffay.26iz7y@NoSpamPleaze.com> wrote in message
news:Rjeffay.26iz7y@NoSpamPleaze.com...
>
> 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
>

Great. But as i wrote i do not know to write the code let alone modify
some of it.


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

> i do not know to write the code

What code are you exactly talking about?

RBS

"Rjeffay" <Rjeffay.26ktvc@NoSpamPleaze.com> wrote in message
news:Rjeffay.26ktvc@NoSpamPleaze.com...
>
> Great. But as i wrote i do not know to write the code let alone modify
> some of it.
>
>
> --
> Rjeffay
> Posted from - http://www.officehelp.in
>

the "code" is the macro. ineed a setup which will not allow a macro to
run unless a password is entered. But I need the password to only
display astericks when entered. I am not knowlegable to create this. I
am looking for some help which I could just put into excel.


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

I still don't understand what the precise problem is.
I am sure it is something simple to solve, but you will have to explain
better what exactly you are trying to do.

RBS

"Rjeffay" <Rjeffay.26mg66@NoSpamPleaze.com> wrote in message
news:Rjeffay.26mg66@NoSpamPleaze.com...
>
> the "code" is the macro. ineed a setup which will not allow a macro to
> run unless a password is entered. But I need the password to only
> display astericks when entered. I am not knowlegable to create this. I
> am looking for some help which I could just put into excel.
>
>
> --
> Rjeffay
> Posted from - http://www.officehelp.in
>