Somehow I changed the view in my VBA editor and all the code and userform open at the bottom of the window. Normally this would be to the right of the Project Explorer/Properties windows. I have docked, undocked, hide, unhide and reset everything I could and I have yet to find a way to put the code window back in the right position. The Project Explorer/Properties window goes completely across with no open space to the right. Any ideas?
1 Answers
I found it. Type regedit in the search window and run the Registry Editor app. From there go to HKEY_Current_User/Software/Microsoft/VBA/7.1/Common. Click on common and it will show all the settings. I simply renamed the DOCK settings so as not to lose them and restarted Excel. The editor was back to normal. I reopened the Registry Editor and found it had created a new DOCK setting file and I still had the renamed setting file. I then deleted it.
Related