Hello,
This is very strange as we have never heard or seen such type of behaviour before. However, let us investigate.
Can you please tell us, are you getting an error? If yes, can you please send us screenshot of it so that we can actually see?
Can you please tell us what exactly your macro does?
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) 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!