"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

The problem is denying access to those for which access is not intended.

Encryption might be one form of solution, but it doesn't appear one very
useful if you are going to use the data on a daily basis.

If you can control physical/electronic access to the file, that should be
sufficient - really depends on what the threat is.

--
Regards,
Tom Ogilvy

"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

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