Remove or Change Password for Multiple PowerPoint Presentations (VBA)

Introduction

This VBA sample illustrates how to remove or change password for multiple PowerPoint presentations.

 

Scenarios

Some users have set password to protect their PowerPoint presentations, and after some time period, the password is no longer required, it turn out to be a huge job to remove password from huge amount of presentations.

 

Script

Import the two files (mdlPassword.bas & ufrmMain.frm).

Step1. Press Alt+F11 to open the VBE in PowerPoint.

Step2. Select these two files and drag them to the Project Explorer (Press Ctrl+R if you cannot see it) or via File >> Import File... (Ctrl+M).

 

Run the Main macro to start user form.

Step3. Go back to the presentation.

Step4. Press the Run button via Alt+F8.

Step5. Select "Main" in the names list, and then click the Run button. We will see the following window:

Note

1. Please make sure that macros are enabled in PowerPoint.

For PowerPoint 2010:

File >> Options >> Trust Center >> Trust Center Settings... >> Macro Settings >> Enable all macros >> OK >> OK >> Restart PowerPoint

 

For PowerPoint 2007:

Office Button >> PowerPoint Options >> Trust Center >> Trust Center Settings... >> Macro Settings >> Enable all macros >> OK >> OK >> Restart PowerPoint

 

For PowerPoint 2003:

Tools >> Macro >> Security... >> Security Level tab >> Low >> OK >> Restart PowerPoint

 

2. Instructions for "password to open" and "password to modify".

Password to open means: file encryption settings for specific document.

Password to modify means: file sharing settings for specific document.

 

Additional Resources

  • Presentation.Password Property (PowerPoint)
  • Presentation.WritePassword Property (PowerPoint)
  •  

    Related forum threads

  • http://answers.microsoft.com/thread/7b76a38b-aacc-40ed-9d61-5665444a3bfe