Hide a Password

R

ryguy7272

I am wondering if there is a way (I assume it won’t be easy) to hide a
password, or otherwise get a password out of Excel. I’m thinking of doing
something with a call to a web server, perhaps. I know password security is
pretty feeble in Excel, so I am curious, and basically hopeful for a
solution, but I’m not holding my breath on this one.

Thanks,
Ryan---
 
A

AltaEgo

You could hard code it and lock up your code with a password, ensuring any
Sub of Function that might give away the password is private so it cannot be
called from the VBA toolbar.

For example, you can use the following in your module but you cannot see it
in the list of available user functions using Insert, Function, User defined
category (XL2003).

Private Function MyPW()
Const YourPW = "yourPassword"
MyPW = YourPW
End Function


Having said that, I would opt for InputBox to grab it on the fly! However,
MyPW = InputBox("Enter Password") leaves the password visible. Here is a way
around this:

http://www.xcelfiles.com/API_09.html

If this doesn't work, try:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20949769.html

Don't ask me to explain and of it - it is beyond my comprehension <bg>
 
R

ryguy7272

Thanks AltaEgo!! Anyone else?
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


AltaEgo said:
You could hard code it and lock up your code with a password, ensuring any
Sub of Function that might give away the password is private so it cannot be
called from the VBA toolbar.

For example, you can use the following in your module but you cannot see it
in the list of available user functions using Insert, Function, User defined
category (XL2003).

Private Function MyPW()
Const YourPW = "yourPassword"
MyPW = YourPW
End Function


Having said that, I would opt for InputBox to grab it on the fly! However,
MyPW = InputBox("Enter Password") leaves the password visible. Here is a way
around this:

http://www.xcelfiles.com/API_09.html

If this doesn't work, try:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20949769.html

Don't ask me to explain and of it - it is beyond my comprehension <bg>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top