View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default VBA Code Security

Hi
just some comments :-)
1. If you use a secure algorithmn just hiding your implementation would
add 'security by obscurity'. IMHO it's never a good idea to achieve
security by hiding the implementation details :-)
2. I can understand that. But for this a simple password would do to
prevent accidentically changes

If you really need security no way without creating a DLL

--
Regards
Frank Kabel
Frankfurt, Germany


TJ Walls wrote:
Hi Bob,


On Thu, 13 May 2004 21:31:08 +0100, Bob Phillips wrote:

So, I think you have more on your plate than it is worth bothering
with. And really, is your code that good? There are dozens of
examples of really good, quality code given free by the regulars
here, and more on various websites,


Umm ... I think your misinterpreting here. Please don't take this
as "My code is sooo great I don't want anyone to see it." I'm not
saying that my _code_ is necessarily any good at all. As I said, in
VBA, I'm a beginner. So I would imagine my code is rather ugly /
inefficient to a seasoned VB coder. It's not the code I'm trying to
protect at all. There are 2 things that security will accomplish for
me here.

1) I use a couple of algrorithms which are common knowledge, but a
view of my exact implementation would compromise data that I would
like to remain relatively secure.

2) Prevents changes to the code without substantial prying. Again,
for security reasons. I could care less about giving out the shell
code for what I'm doing.

I would hope trying to lock down my code is not seen as a jab to
you or anyone else who gratefully contributes their knowledge to this
newsgroup.

-TJ Walls
Ph.D. Candidate - Dept. of Physics, Stony Brook University