Is it normal that I can't click anything in VBA editor after switching back to spreadsheet to copy something? It's very annoying to have to right click a button -> macros -> select macro -> edit macro every time I switch back to spreadsheet. How do I disable the VBA editor from locking itself up? I'm making a series of buttons and need to copy/paste a lot of text into VBA editor. There are no macros running, not sure why this is happening. I'm using Excel 2010.