Whoever it may concern,
My workbook has a macro that users click to transfer data from one sheet to another in a flat sheet format. I need each user to ensure their formulas are set to Manual when they click save for the macro to run properly, which has been fine. However, if a user has another workbook open first that is set to automatic, it changes this sheet to automatic and messes up all of the existing data. Any ideas? Can I create a separate macro that puts the worksheet on Manual BEFORE the workbook is opened?
Bookmarks