Passowrd Protect PPT in VBA code

[Bobbbo]

I would think this one would be easy, but I found PowerPoint does not have a macro record feature, so I am stuck. I have a VBA program in Excel that creates a PowerPoint file. When complete I save it

Please Login or Register  to view this content.

All I am looking to do is save it with a password in cell B17 of the current tab in Excel.

Any ideas?

[cytop]

It may be PowerPoint VBA, but does this do what you want?

[Bobbbo]

Hi cytop, For some reason I am not seeing any code?

[Norie]

You can use the presentations WritePassword property to set a password.

[Bobbbo]

You can use the presentations WritePassword property to set a password.

Can you show me an example?

[Norie]

Assuming PP is a reference to your presentation.

Please Login or Register  to view this content.

[Bobbbo]

Assuming PP is a reference to your presentation.

Please Login or Register  to view this content.

Thanks I got it to work, but I can still can open the PPT file as read only to get around the password. Is there a different command for that?

[Norie]

I don't think so, the WritePassword property is really only to prevent the presentation being changed.

[Bobbbo]

I don't think so, the WritePassword property is really only to prevent the presentation being changed.

Within PowerPoint you can encrypt the file with a password that is required to open the document. That is what I need but in VBA code.

[Norie]

I'm sorry but as far as I know it's not possible to set that kind of protection usng VBA.

[Bobbbo]

I'm sorry but as far as I know it's not possible to set that kind of protection usng VBA.

Darn that is too bad!!!

[Bobbbo]

I was lead to believe anything you can do manually in PowerPoint or Excel you can perform in VBA code. Anyone else have any ideas on how to password protect a PPT file with VBA Code?