For weeks now I have had the mild annoyance that the VBA code editor for various Excel spreadsheetâs appear to be opening at ârandomâ?. I finally tracked it down to me unlocking my PC. If I have excel running then lock my PC, when I unlock it, the VBA code editor appears.
Iâm using Office 2003 SP3 on XP Pro SP3.
Turns out that there is a VERY easy fix â donât maximise the VBA code editor.
If the editor is maximised, it appears on unlock, if it is not maximised it does not appear automatically on unlock.