Following are few points that should be considered while recording a macro for its errorless execution.
1) While recording we recommend using more of keyboard short cuts instead of mouse clicks as they are more reliable than mouse moves/clicks irrespective of change in screen resolution or window size. Mouse clicks/moves are subject to work on a screen resolution they were recorded on. However, keystrokes will work as expected no matter whatever screen resolution you set to. For e.g. Up/Down arrow key would work in a reliable way than using mouse to scroll in an excel sheet.
2) While recording after you perform an action, wait for few seconds so that command gets enough time to execute on replay. Insufficient delay can skip any command and hence can mess up the commands. After recording, you can also edit your macro through Tools->Macro Editor to insert Delay command (Available in Workspace Macro Pro 6.5).
3) Using Workspace Macro Pro you can edit mouse clicks to perform activities relative to windows. Please follow the steps given below:
. Double click on Mouse Click command.
. Click on 'Advanced' button.
. From 'Relative To' frame select option 'Window' and save the command.
. Perform the above steps for every Mouse Click command in question.
. Save the macro and run it.
4) Here is a link to best practices for our macro products, Workspace Macro 4.6 and Workspace Macro Pro 6.5
http://www.tethyssolutions.com/bestpractices.htm
Hope that helps!