Possible bug when opening the VB editor while using multiple screens (Mac)

%3CLINGO-SUB%20id%3D%22lingo-sub-1890929%22%20slang%3D%22en-US%22%3EPossible%20bug%20when%20opening%20the%20VB%20editor%20while%20using%20multiple%20screens%20(Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1890929%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22css-xu5cua%22%3E%3CDIV%20class%3D%22css-1gwxaay%22%3E%3CDIV%20class%3D%22message-bubble-container%20css-qxtrfg%22%3E%3CDIV%20class%3D%22css-xu5cua%22%3E%3CDIV%20class%3D%22css-ocvvgq%22%3E%3CDIV%20class%3D%22css-rd2992%22%3E%3CDIV%20class%3D%22css-1rg7bkd%22%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EHello%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EI%20have%20found%20a%20weird%20issue%20with%20Excel%20%2F%20VBA%20during%20an%20assignment%20I%20was%20working%20on.%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EI%20asked%20Office%20support%20about%20it%20and%20the%20agent%20in%20live%20chat%20directed%20me%20to%20ask%20here.%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3ETo%20try%20and%20explain%20it%20I%20have%20prepared%20a%20short%20step-by-step%20of%20the%20issue%20and%20outcome%20I%20encountered%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EI%20understand%20that%20it%20is%20relatively%20easy%20to%20circumvent%20by%20paying%20attention%20to%20what%20you%20open%20on%20which%20screen%20(once%20you%20know%20about%20it)%2C%20but%20sadly%20I%20lost%20over%20an%20hour%20of%20work%20due%20to%20this%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EProblem%201%3A%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E1.%20Open%20Excel%20(opens%20on%20the%20screen%20you%20are%20currently%20active%20in)%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E2.%20Open%20a%20workpiece%20(the%20spreadsheet%20window%20will%20open%20on%20the%20primary%20screen)%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E3.%20Move%20the%20work%20window%20to%20the%20secondary%20screen%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E4.%20Open%20the%20VB%20editor%20from%20excel%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E-%20it%20will%20open%20on%20the%20primary%20screen%2C%20but%20off%20the%20screen%20and%20it%20can't%20be%20moved%20to%20any%20of%20the%20screens%20or%20virtual%20desktops%2C%20even%20though%20it's%20visible%20in%20mission%20control.%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EIf%20you%20restart%20excel%20and%20open%20the%20VB%20editor%20before%20step%203%20it%20works%20fine.%20Apart%20from%20the%20VB%20editor%2C%20Excel%20is%20still%20usable%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3EAn%20extension%20of%20the%20previous%20problem%3A%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E1.%20Open%20Excel%20(opens%20on%20the%20screen%20you%20are%20currently%20active%20in)%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E2.%20Open%20a%20workpiece%20(the%20spreadsheet%20window%20will%20open%20on%20the%20primary%20screen)%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E3.%20Open%20the%20VB%20editor%20(still%20on%20the%20primary%20screen)%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E4.%20Move%20the%20VB%20editor%20to%20the%20secondary%20screen%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E5.%20Open%20preferences%20in%20the%20VB%20editor%3C%2FDIV%3E%3CDIV%20class%3D%22css-1ecggw1%22%3E-%20it%20will%20open%20on%20the%20primary%20screen%2C%20but%20off%20the%20screen%20and%20it%20can't%20be%20moved%20to%20any%20of%20the%20screens%20or%20virtual%20desktops%2C%20even%20though%20it's%20visible%20in%20mission%20control.%20Having%20this%20preferences%20window%20open%20prevents%20Excel%20from%20being%20used%20or%20closed%20either%20with%20the%20mouse%20or%20with%20the%20cmd%2BW%20or%20cmd%2BQ%20shortcuts.%20It%20also%20prevents%20the%20Mac%20from%20signing%20out%2C%20restarting%20or%20shutting%20down.%20The%20Mac%20is%20otherwise%20usable%2C%20but%20to%20close%20Excel%20you%20have%20to%20force%20shut%20down%20the%20program%20from%20the%20activity%20monitor%2C%20or%20the%20whole%20computer%20by%20holding%20the%20power%20button%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22css-c2lyy8%22%3E%3CDIV%20class%3D%22css-1ug488v%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22css-ry3ph8%22%3EExcel%20Version%3A%2016.43%20(20110804)%3C%2FDIV%3E%3CDIV%20class%3D%22css-ry3ph8%22%3ELicense%3A%20Microsoft%20365%20subscription%20(provided%20by%20my%20university)%3C%2FDIV%3E%3CDIV%20class%3D%22css-xu5cua%22%3E%3CDIV%20class%3D%22css-1gwxaay%22%3E%3CDIV%20class%3D%22css-xacoxn%22%3EmacOS%20version%20(when%20I%20first%20encountered%20the%20issue)%3A%2010.15.7%3C%2FDIV%3E%3CDIV%20class%3D%22css-xacoxn%22%3EmacOS%20version%20(current)%3A%2011.0.1%3C%2FDIV%3E%3CDIV%20class%3D%22message-bubble-container%20css-qxtrfg%22%3E%3CDIV%20class%3D%22css-xu5cua%22%3E%3CDIV%20class%3D%22css-ocvvgq%22%3E%3CDIV%20class%3D%22css-rd2992%22%3E%3CDIV%20class%3D%22css-t3xtxo%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1890929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1894228%22%20slang%3D%22de-DE%22%3ESubject%3A%20Possible%20bug%20when%20opening%20the%20VB%20editor%20while%20using%20multiple%20screens%20(Mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894228%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F870445%22%20target%3D%22_blank%22%3E%40NotDomm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20for%20excel%20for%20mac%2C%20my%20knowledge%20is%2C%20to%20put%20it%20mildly%2C%20very%20limited.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20send%20you%20this%20information%2C%20it%20may%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20a%20Mac%20specialist%20will%20see%20your%20post%20again%20and%20may%20have%20a%20solution%20that%20can%20help%20you%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%20history%20for%20Office%20for%20Mac%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-office-for-mac%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-office-for-mac%3C%2FA%3E%3C%2FP%3E%3CP%3ERelease%20notes%20for%20Office%20for%20Mac%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Frelease-notes-office-for-mac%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Frelease-notes-office-for-mac%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20at%20least%20a%20little.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor
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
 
Excel Version: 16.43 (20110804)
License: Microsoft 365 subscription (provided by my university)
macOS version (when I first encountered the issue): 10.15.7
macOS version (current): 11.0.1
 
1 Reply
Highlighted

@NotDomm 

As for excel for mac, my knowledge is, to put it mildly, very limited. But send you this information, it may help you. Or a Mac specialist will see your post again and may have a solution that can help you:).

 

Update history for Office for Mac

https://docs.microsoft.com/en-us/officeupdates/update-history-office-for-mac

Release notes for Office for Mac

https://docs.microsoft.com/en-us/officeupdates/release-notes-office-for-mac

 

Hope I could help you at least a little.

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)