How To Get VBA Code From Add-In

You can retrieve VBA code from an add-in if

  • the VBA project hasn't been password protected
  • you know the password for the VBA project

If the above conditions are met, then follow these steps to retrieve VBA code from an add-in.

  1. Make sure that PowerPoint is not running.
  2. Launch Registry Editor.
  3. Navigate to the key HKEY_CURRENT_USER\Software\Microsoft\Office\x.y\PowerPoint\Options
  4. Set the value of DebugAddins to 1. If you don't see DebugAddins, then create a DWORD value and name it DebugAddins.
  5. Launch PowerPoint.
  6. Make sure that you have loaded your add-in.
  7. Open VBE.

You will see the add-in listed there. You can also see the add-in code there.

The x.y key in the above steps should be replaced with

  • 8.0 for PowerPoint 97
  • 9.0 for PowerPoint 2000
  • 10.0 for PowerPoint XP (also known as PowerPoint 2002)
  • 11.0 for PowerPoint 2003
  • 12.0 for PowerPoint 2007
  • 14.0 for PowerPoint 2010
  • 15.0 for PowerPoint 2013
Contact OfficeOne on email at officeone@officeoneonline.com. Copyright © 2001-2023 OfficeOne. All rights reserved.