I had similar issue.
In my environment, if I logged in as a different user the VBA editor worked within Solidworks.
The way I resolved it was to copy the registry settings for
HKEY_CURRENT_USER\Software\Microsoft\VBA from the working user.
Then logging into the user that didn't work. I did...