https://issues.apache.org/ooo/show_bug.cgi?id=124723
--- Comment #13 from Jack Mathis <[email protected]> --- I don't know why there isn't any macro in the file that I uploaded, as it is in my file. Perhaps it got stripped out somehow? Anyway the macro shown in comment 6 is precisely what my macro shows. I haven't tried un-remarking the goal seek dialog line, as I feel the having to enter the dialog every time I run the macro kind of defeats the purpose of the macro. I'm also baffled as to why a dispatch statement is left in the macro, even though it does nothing. Why not Rem that out also, so the user can tell that the macro isn't going to do anything. Better yet, stick in a flag that indicates that you have done something that isn't supported. It isn't that using the mouse messes things up, as you can record the macro using only key strokes. (tedious, but doable) Also, if you use the mouse to click on the next cell instead of using the arrow key, that part works, although it produces a slightly different macro. Further, the fact that the goal seek statement is in the macro reflects the fact that the recorder has recognized that I've gone up to the tools menu and selected the "Goal Seek" command (with the mouse). The problem is simply that the recording system is not recording the dialog, as was stated very clearly in comment 11. I have managed to find some documentation and an example of code using goal seek, but I haven't had a chance to try it yet. I feel I can probably work around this issue. Many thanks to the references in the comments, which led me in the right direction. Finally, it would seem that some improvement in the documentation of the macro limitations would be helpful. Thanks again to all. Jack -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
