parenthesis do not match - macro error

Version: 6.1.3.2 (x64) Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 12; OS: Windows 10.0; UI render: default; Locale: en-AU (en_AU);

[WARNING] - macros exist but do not reference outside themselves

I have a problem in a macro where the parenthesis do not match. I know where the problem is but cannot access it to fix it.
When trying to open the document I get basic system error.
How do I get in passed this to correct it.

Cheers,
Gary.

cost comparison.ods

parenthesis.PNG

Solved it by setting MACRO security to very high. This stopped the macros from running but allowed me to go in and edit the code.

It’s enough to set security level to medium - which would ask if you want to run the macros in the document, giving you a chance to avoid running the macro, or allow it when you want to test it.

Yes that is enough.
Mike, thanks for the support.