Hello
I have found a weird issue with Excel / VBA during an assignment I was working on.
I asked Office support about it and the agent in live chat directed me to ask here.
To try and explain it I have prepared a short step-by-step of the issue and outcome I encountered
I understand that it is relatively easy to circumvent by paying attention to what you open on which screen (once you know about it), but sadly I lost over an hour of work due to this
Problem 1:
1. Open Excel (opens on the screen you are currently active in)
2. Open a workpiece (the spreadsheet window will open on the primary screen)
3. Move the work window to the secondary screen
4. Open the VB editor from excel
- it will open on the primary screen, but off the screen and it can't be moved to any of the screens or virtual desktops, even though it's visible in mission control.
If you restart excel and open the VB editor before step 3 it works fine. Apart from the VB editor, Excel is still usable
An extension of the previous problem:
1. Open Excel (opens on the screen you are currently active in)
2. Open a workpiece (the spreadsheet window will open on the primary screen)
3. Open the VB editor (still on the primary screen)
4. Move the VB editor to the secondary screen
5. Open preferences in the VB editor
- it will open on the primary screen, but off the screen and it can't be moved to any of the screens or virtual desktops, even though it's visible in mission control. Having this preferences window open prevents Excel from being used or closed either with the mouse or with the cmd+W or cmd+Q shortcuts. It also prevents the Mac from signing out, restarting or shutting down. The Mac is otherwise usable, but to close Excel you have to force shut down the program from the activity monitor, or the whole computer by holding the power button