Securing an Excel application
 

I've done quite a bit of reading from this group regarding excel
application security. It is fairly clear to me that password
protecting worksheets and VBA projects does not provide much security.
These passwords appear to be more an annoyance than anything and can
surely be broken easily and quickly.

From what I read, it seems that the only way to provide real security
is to develop the application into a DLL using VB or similar. Is this
a fair assessment, or is there a means by which true security can be
incorporated into an application?

Regards,
John

Securing an Excel application
 

Thats a pretty fair assessment.
Excel passwords work to keep the casual user from messing things up. Anyone
with a little knowledge or the desire to gain access to you VBA code can
easily do it even if password-protected.

VB makes it much more difficult - not impossible - to hack.

The reason has to do with compiled vs. interpreted code which I
could not explain in detail even if there were room here.

" wrote:

I've done quite a bit of reading from this group regarding excel
application security. It is fairly clear to me that password
protecting worksheets and VBA projects does not provide much security.
These passwords appear to be more an annoyance than anything and can
surely be broken easily and quickly.

From what I read, it seems that the only way to provide real security
is to develop the application into a DLL using VB or similar. Is this
a fair assessment, or is there a means by which true security can be
incorporated into an application?

Regards,
John