If you can find a suitable encryption/decryption algorithm which uses a
passphrase not stored in the workbook (you would have to enter it manually
in each session) then that might work.

It really depends on how secure you need the information to be. As Tom
notes, just controlling access to the file might be enough for your
situation.

Tim.

--
Tim Williams
Palo Alto, CA


"Lydon Bergin" wrote in message
...
"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
You should not rely on Excel security when storing "sensitive"
information.
Workbook/worksheet/VBA project passwords are all easily cracked by
anyone
who knows enough to google for the method.

If your encryption/decryption method is implemented in VBA then it would
also be accessible to anyone who obtained your file, and they could use
your
routine to decrypt the data.

Tim

Any idea how (besides saving to a database) I can save this information
securely?

Lydon D. Bergin
MCP, MOS