Go to Tools -> Macros -> Visual Basic Editor (or hit Alt-F11). This will bring up the VBA editor.
Macros will be listed in the left-hand pane under “Desktop Intelligence Objects”. Right-click on each one and hit “Remove”. You will be asked if you want to export the macro – you can do this to keep a backup in a text file.
There might also be Class Modules or User Forms in the project panel; you can delete those too (assuming, of course, that you’re sure you don’t need them).
Macros are part of the .rep file, so yes - you can remove macros from one document without affecting macros in another document.
Some more info here: https://wiki.scn.sap.com/wiki/display/BOBJ/VBA+fundamentals
joepeters (BOB member since 2002-08-29)