Forum Discussion
Excel 365 64-bit: Out of memory when editing VBA in an existing XLSM
Hello, Microsoft Support referred me to this community because they could not resolve an Excel VBE editing issue. Environment: Microsoft 365 Excel for Windows, 64-bit; Version 2610, build ...
Perhaps the VBAProject has a corruption of some sort. Right-click each module in turn and choose "Export". Save it. Then right-click again and choose Remove module (click No to export as that was already completed)
Save the file, close it and re-open it.
Right-click the project in the VBE and select Import. Import the saved module(s). Now try again.