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.
- Make sure that PowerPoint is not running.
- Launch Registry Editor.
- Navigate to the key HKEY_CURRENT_USER\Software\Microsoft\Office\x.y\PowerPoint\Options
- Set the value of DebugAddins to 1. If you don't see
DebugAddins, then create a DWORD value and name it DebugAddins.
- Launch PowerPoint.
- Make sure that you have loaded your add-in.
- 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
|
|