Hi,
I'm facing a problem. I open two separate applications of Excel, one application has a spreadsheet that will run a Macro (every 10 mins. or so) and the other application has a spreadsheet that links (I think via OLE) to the spreadsheet that is running the macro. If both spreadsheets are open in the same application of Excel, every time the macro runs it takes me away from the spreadsheet I am trying to work on and puts in the spreadsheet the macro is running on, interrupting me. Ideally, I'd like to have one excel application open and two spreadsheets - me being able to work on the one that links to the macro spreadsheet uninterrupted and the other running the macro in the background. My question is: Must I continue to use two separate applications of Excel or is there a way to get around this problem? Thanks a ton!!