Uncheck the "Check Compatibility" box, or remove the links.

I wanted to follow up on my post from yesterday. After some experimenting, I've determined that this is an issue with Microsoft Excel. In my case, it's Excel 2019. I fired up my old desktop running Win 10 & Excel 2007 and ran the same VBA unimpeded. It worked as expected without any compatibility warnings. I know this solution won't help everyone, but at least there's a way if you have an older desktop around. In the meantime, I'll still keep searching for a way to get things to work under Excel 2019 or later.

Chris

I solved my compatibility issue.  I realized that the templates I was using to generate the FS were made 20 years ago.  Why I only started getting comp. warnings last week....who knows.  Anyway, I opened a new excel workbook, copied the code from the old templates, saved...boom fixed.  

I solved my compatibility issue.  I realized that the templates I was using to generate the FS were made 20 years ago.  Why I only started getting comp. warnings last week....who knows.  Anyway, I opened a new excel workbook, copied the code from the old templates, saved...boom fixed.