accessing/reading vba macro without enabling macros
 

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?

accessing/reading vba macro without enabling macros
 

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?

accessing/reading vba macro without enabling macros
 

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

accessing/reading vba macro without enabling macros
 

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 .....

accessing/reading vba macro without enabling macros
 

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.