Our Visual Basic support is not complete, and so the most likely explanation is that in the Macros that fail you're calling on functions that are not present in Crossover right now. There aren't really any changes you can make to Crossover or Excel to enable better VB support macros - either they will "just work" or they won't.
In cases where they won't, we encourage users to file tickets with regards to the specific Macro so we can create a bug and eventually implement support for that function.
Finally I found a solution : I create a new document from my old one and then I can create macros until I save and close it.
If I need to create an other macro I need to duplicate the file again.
Please Note: This Forum is for non-application specific questions relating to installation/configuration of CrossOver. All application-specific posts to this Forum will be moved to their appropriate Compatibility Center Forum.
CrossOver Forums: the place to discuss running Windows applications on Mac and Linux
CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.