I have a macro in my XLS file that is taking 100% of my CPU - I think
it is a bug in my code. When I open the XLS, Excel freezes up and I
have to kill it from task manager. I would like to open the XLS file
and disable the code, but be able to look at it and edit it (and
comment out any offending lines, or at least copy my code to the
clipboard). However if I disable macros upon opening Excel, it won't
let me even see my code. How can I view my code without running?

I hope I don't get shot for mentioning this on a Microsoft based forum but
you could go to the competor. OpenOffice.org offers an office suite that is
comparable to Office 2003 and it would allow you to open up the excel file
without it activating the macro.

You could also open a new excel file and Go to Tools-Macro-Security
and turn the Security level to high which would efectively disable all macros

Hope this helps
-Sooth

"Mad Scientist Jr" wrote:

I have a macro in my XLS file that is taking 100% of my CPU - I think
it is a bug in my code. When I open the XLS, Excel freezes up and I
have to kill it from task manager. I would like to open the XLS file
and disable the code, but be able to look at it and edit it (and
comment out any offending lines, or at least copy my code to the
clipboard). However if I disable macros upon opening Excel, it won't
let me even see my code. How can I view my code without running?

If you think OpenOffice is comparable to Excel, you are using less than 5% of
Excel's capability .....

LOL, well I guess "comparable" is a typo. I mean bearable.

"AA2e72E" wrote:

If you think OpenOffice is comparable to Excel, you are using less than 5% of
Excel's capability .....

I guess OpenOffice has its place, where Excel does not run or on the Excel
bandwagon; they do say that immitation is the sincerest form of flattery.