Ask Your Question
1

parenthesis do not match - macro error

asked 2019-03-16 04:38:40 +0200

GaryDown gravatar image

updated 2019-03-16 05:09:23 +0200

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.

C:\fakepath\cost comparison.ods

C:\fakepath\parenthesis.PNG

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-03-16 05:36:58 +0200

GaryDown gravatar image

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.

edit flag offensive delete link more

Comments

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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-16 10:26:03 +0200 )edit

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

GaryDown gravatar imageGaryDown ( 2019-03-17 04:42:33 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-03-16 04:38:40 +0200

Seen: 29 times

Last updated: Mar 16