I am wondering if there is a way (I assume it wont be easy) to hide a
password, or otherwise get a password out of Excel. Im 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 Im not holding my breath on this one.

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

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/Micr..._20949769.html

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

--
Steve

"ryguy7272" wrote in message
...
I am wondering if there is a way (I assume it wont be easy) to hide a
password, or otherwise get a password out of Excel. Im 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 Im not holding my breath on this one.

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

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


"AltaEgo" wrote:

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/Micr..._20949769.html

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

--
Steve

"ryguy7272" wrote in message
...
I am wondering if there is a way (I assume it wont be easy) to hide a
password, or otherwise get a password out of Excel. Im 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 Im not holding my breath on this one.

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.