Set your security to medium and when the dialog ask whether you wnat to
enable macros just say no. Now you can edit the code...
--
HTH...

Jim Thomlinson


"Jim D." wrote:

I have a spreadsheet from someone else that contains a macro that runs when
the workbook opens. I want to edit that macro, but since the macro also
saves the workbook with a new name, I cannot get to the macro (without
triggering it). Is there any way to edit the macro outside of Excel?