With Excel opened, but not the problem Wkbook, change Macro Security to
HIGH.
Then open the problem Wkbook to edit it.


Corey....

"Dudely" wrote in message
...
Thanks, but as I stated in the original post:

" Now it crashes everytime I bring up this particular workbook. I
get as far as Enable or Disable macros. Upon choosing one or the
other (it doesn't matter which I choose) Excel immediately crashes."

Therefore, since Excel crashes immediately upon opening the workbook,
I'm unable to use the VB editor and step through the code. Further,
since it crashes even if I choose Disable Macros, it's clearly not
running my code.

Anyone else have any good ideas?

Thank you


On Aug 24, 4:52 pm, JLGWhiz wrote:
You have written some code that VBA does not like. It is confusing the
compiler with something that is not handled in trappable error category,
so
it shuts down.
You can attempt to walk through the code one line at a time to see if you
can detect the problem code and fix it by opening the VB editor and using
F8
to step through the code.



"Dudely" wrote:
I'm using Excel 2000 under Windows XP Pro. I recently wrote some VBA
code, and had it mostly working when Excel started to first hang - and
then crash. Now it crashes everytime I bring up this particular
workbook.

I get as far as Enable or Disable macros. Upon choosing one or the
other (it doesn't matter which I choose) Excel immediately crashes.

I run AVG and Superantispyware (free versions) around the clock. I
ran superantispyware scan, spyware blaster, ad aware and anti-
malware. While they each found a couple of things, I cleaned them out
and Excel is still crashing.

Excel ONLY crashes when I bring up this one specific workbook. Being
as how I worked on the VBA code all week and it's something I really
need, I'd prefer not to have to re-write it all.

It's only 98 KB. I have no add-ins. I deleted the one .xlb file I
found, it was 8 KB.

Any ideas?

Thank you in advance- Hide quoted text -

- Show quoted text -