Mail them a CD via the Postal Service.
Media rates are very reasonable.
-or-
Supply the password to the user.
Jim Cone
San Francisco, USA
"Kaisies" wrote in message
...
Is it just me, or is it an incredible shortcoming that you cannot
programmicly remove a VB Project password?
If you need to change any of your code, which happens, what, all the time?
your out of luck, period. Send the user a new sheet. What if the user
can't get the new sheet? oh well, more out of luck then. Distributing a
workbook with unlocked VB Projects is completely out of the question, so
where does that leave you?
I have a 8meg excel doc that i need to make code changes to, 500 miles away,
but oh well. I can't. The VB Project is locked. And I can't distribute a
new Excel workbook, they are on dial up. What can be done in a situation
like this?