VBA causing "Excel has encountered a problem" message
Did you either make a backup copy of this file or export the VBA code to a
"BAS" file?
Have you tried opening up Excel only, set the security level to medium (if
not already there), go into design mode, set the "Application.EnableEvents"
to false (This can be done via the immediate window on the VBA side), and
then open the file? Also, if you have UDFs, make sure calculation mode is
set to manual before opening up the file.
--
Sincerely,
Ronald R. Dodge, Jr.
Master MOUS 2000
"arch" wrote in message
...
Added new VBA routine to Excel 2000 file which caused termination of
Excel.
The message occurs even if disable micros or when saved as a csv file.
Any
other options to be able to open the file and correct the faulty VBA code?
|