YOU can. In fact anybody who knows the password can remove it, including your
users. The point is not WHO can remove the password, but that this step must
be done manually. It can't be done through code.

Perhaps your real problem is faulty design of your project. Have you
considered separating the user's data (presumably this huge workbook) from
your code, which should be in a (presumably much smaller) add-in? Then you can
modify the code and distribute a new add-in when needed, and the issues of
passwords and file size are moot.


On Fri, 25 Mar 2005 17:43:02 -0800, "Kaisies"
wrote:

Whats the point of a password if YOU cannot remove it?

"Myrna Larson" wrote:

Shortcoming???? What't the point of a password if another person can remove
it. Wouldn't the virus writers just love that? If you don't want a
password,
don't apply one in the first place.


On Fri, 25 Mar 2005 17:05:06 -0800, "Jim Cone"
wrote:

Is it just me, or is it an incredible shortcoming that you cannot
programmicly remove a VB Project password?