Excel VBA Password Vulnerability

[Tom]

Hi All,

I have written an Excel spreadsheet which I share with others, who may
then share with others.... I would like to keep my coding in the VBA
Project private.

Doing some research on the web, I found that password protecting the
VBA Project provides protection which is easily sidestepped by various
"Password Recovery" software packages, many of which are free.

Can I protect my code in some other way? Is there no hope for
Microsoft security?

Thanks,
--Tom.

 

[Guest]

I recommend doing what everyone else does and writing incomprehensible code

G

 

[JE McGimpsey]

Compile the code into a COM add-in.

 

[Tom]

Thanks guys.

JE: I'll look into that COM add-in business, although it sounds like a
headache. But I guess that's what security is these days.

G: I had actually considerred that option! But it just sucks so bad, I
couldn't bear to do it.

--Tom.

 

[Tom]

I'm quite comfortable writing in VBA, user forms, etc. So when I
looked into creating a COM add-in, the instructions I found seemed
acceptable to me. I think I can handle it.

Except that I don't have any actual developer software. It seems I
need to buy Visual Studio or Microsoft Office XP Developer in order to
creat an actual add-in, COM object, or dll. I don't think I can do it
with my MS Office 2003 XP Pro. Is this true?

Help?

--Tom.

 

[Chip Pearson]

In the VBA Editor, go to the File menu and see if you have a "New Project"
item. If you do, choose it and then choose "Add-In Project". This will give
you the framework for creating a COM Add-In.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)