I've found that if you use copy and paste functions in your macro, it ties up the ability to use the spreadsheet. I'm guessing select functions would do the same. But if you are instead saying one cell equals a value in another cell or a formula rather than copy/paste you can still move around and even edit the spreadsheet while the macro is running.