I wrote custom VBA functions in Excel that stop continuously calculating when I activate a different workbook. They are populated with RTD streaming from ThinkorSwim and generate audible alerts when certain conditions are met. They work great until I open/activate another workbook and then they display #Value . If I go back to the workbook with the functions and click on it to make it active again the functions start calculating again. Is this typical? And does anyone know a possible workaround?
Note: The RTD formulas in the spreadsheet continue to work even when the 2nd workbook is active. Using 2019 64bit Excel.
Note: The RTD formulas in the spreadsheet continue to work even when the 2nd workbook is active. Using 2019 64bit Excel.
