Open up both workbooks, Open UP VBA in the Workbook with the Macros and then Select a Cell in the Workbook that I want to Change.
I make my macros run and the workbook I frequently upload and download is free of macros so the Excel Web App is Happy.