Hi - I moved to office 365 today form Windows 10. Have a situation I am investigating.
1.User has multiple instances of excel open. One with a macro, one with other files.
2.User selects macro button on a workbook to run and macro starts as expected. Macro in this instance is pulling data from a system and writing data to a worksheet on that macro workbook
3.While macro is running – they select other excel window/instance to multi task and look at other workbooks/ files not related to macro
4.Macro starts writing to the other excel window/instance and overlays what data is on their non macro file.
What setting or alternative solution do I need to select/deselect to prevent the macro from bleeding into the other workbook and to keep macro to its dedicated workbook