Support for VBA access on macOS #8
Description
Unfortunately, any attempts to support vba-edit functionality on macOS have to be abandoned at this stage.
Key obeservations:
- Basic Excel automation (reading/writing cells) works on macOS through appscript
- VBA module access/modification is not possible on macOS
This appears to be part of the macOS sandboxing security model which restricts code modification capabilities.
Any attempts to modify VBA modules directly on macOS have failed and this appears to be a fundamental platform limitation rather than just a technical challenge to overcome.
If this should change in future versions of Excel for macOS. This issue will be reconsidered.
In case anyone in the open-source community comes to a different conclusion, help is welcome and appreciated.