I tried that. The workbook opens with a message saying "you must enable
macros," and when I go to view macros, there aren't any listed. But I can
view the Excel file in a text editor and see some of the commands--for
example, the one that saves the spreadsheet with a new name. Very puzzling.

Jim Dutton
==================

"Norman Jones" wrote:

Hi Jim,

You can disable code that runs when workbook opens by depressing the Shift
key when you open the workbook.


---
Regards,
Norman



"Jim D." wrote in message
...
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?