Excel VBA Password Vulnerability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 16 Sep 2006 07:49 GMT

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.

Reply to this Message

glenton (glenton@leviqqio.com - 16 Sep 2006 12:12 GMT

I recommend doing what everyone else does and writing incomprehensible code ;)

G

> Hi All,
>
[quoted text clipped - 11 lines]
> Thanks,
> --Tom.

Reply to this Message

JE McGimpsey - 16 Sep 2006 20:54 GMT

Compile the code into a COM add-in.

> Hi All,
>
[quoted text clipped - 8 lines]
> Can I protect my code in some other way? Is there no hope for
> Microsoft security?

Reply to this Message

Tom - 18 Sep 2006 01:29 GMT

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.

> Compile the code into a COM add-in.
>
[quoted text clipped - 10 lines]
> > Can I protect my code in some other way? Is there no hope for
> > Microsoft security?

Reply to this Message

Tom - 19 Sep 2006 23:17 GMT

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.

> Thanks guys.
>
[quoted text clipped - 20 lines]
> > > Can I protect my code in some other way? Is there no hope for
> > > Microsoft security?

Reply to this Message

Chip Pearson - 14 Nov 2006 04:25 GMT

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.

Signature

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

> 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
[quoted text clipped - 35 lines]
>> > > Can I protect my code in some other way? Is there no hope for
>> > > Microsoft security?

Reply to this Message