G
Guest
I updated a workbook that is becoming widely distributed. I have tried to
keep it running on Office 97 computers but this latest problem has me
stumped. On computers with Office 97, Excel will not allow me to open the
module to trace the offending code. I added " If Val (Application.Version) >
8 Then... " to try and trap the recently added lines. Didn't help.
The added lines that I thought were causing this are:
Application.DisplayAlerts = False
..
..
and Application.DisplayAlerts = True
I don't think these are causing the problem anymore.
Is there a way to decompile an Excel file so that I might be able to again
open the file with 97 ? I really need to be able to trace the logic.
The program only fails when one macro is called. The rest of the program
works fine.
keep it running on Office 97 computers but this latest problem has me
stumped. On computers with Office 97, Excel will not allow me to open the
module to trace the offending code. I added " If Val (Application.Version) >
8 Then... " to try and trap the recently added lines. Didn't help.
The added lines that I thought were causing this are:
Application.DisplayAlerts = False
..
..
and Application.DisplayAlerts = True
I don't think these are causing the problem anymore.
Is there a way to decompile an Excel file so that I might be able to again
open the file with 97 ? I really need to be able to trace the logic.
The program only fails when one macro is called. The rest of the program
works fine.