Macros are not executing properly. Execution is on different rows that the ones recorded. Also, when creating button, the correct menu including form control, does not pop up. Should each macro have its own module? Should macros only be stored under a module for the specific file or in general? I am using version 7.4.7.2, but have also tried version 7.5 and it did not work either.
Should each macro have its own module?
No…
Without seeing your code, it’s hard to help you.
.
The Recorded macros are static - usually. They only work on the cell range where they was recorded.
.
You need WRITE your macros (based on the API functions) - if you want to work with macros dinamically and efficiently.
.
Please upload an ODF type sample file here together with the embedded macro code.
Depends on your macro. I have some “export to” macros. Some are for general use and in “my” library. Some of the special type (export sheet 3 and 5 under special names, then call external script and send result by mail) reside in the file itself, as they are useless anywhere else.
.
Some “general use” macros I put in the file, as this is sent to a coworker. Therefore we both use the same version of the macro, when using this file.
“You need WRITE your macros (based on the API functions) - if you want to work with macros dinamically and efficiently.”. What does this mean? There was no sample included
I supposed that your macro was “recorded” by the Macro Recorder. The MR can record a static code only with absolute references. You must modify/rewrite these macros to make them dynamic (for example if you want to use it for the “actually selected row”). And you must use the API functions to achieve it.