export a workbook to a password protected zip file, using the default windows zip program

[Alina Loredana]

Hi all,

I know this subject has already been discussed, but I didn't find anything about protecting it with a password.

So here's what I need. I have a workbook that I need to zip and protect with a password, via vba (i'm using a button), but using the default Windows zip program, as it will be used be a great number of people, who may or may not have a specific zip program.

I have to mention that I already used Ron de Bruin's code (http://www.rondebruin.nl/win/s7/win001.htm), and it worked, just that it doesn't cover the whole password protection problem.

Many thanks in advance, hope someone has a solution.

[Alina Loredana]

any idea how to do this?