View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default How do you edit macros outside of Excel?

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?