. I am not clear exactly what you are saying or asking.
. However if it is an issue of looking at either the Spreadsheet ot the Development Environment (Your code or "macro") , then if you are able to organize it I would strongly recommend trying to set up your computer with an additional screen( extended monitor option ).
: You can clearly then see both your "Macro" and the Spreadsheet without having to minimize or hit ALT 11 to switch between the two