Excel VB Code Issue with Cell Editing in Excel 2019

Question

I'm currently facing a issue with my VB code that interacts with Excel. Here's the scenario: I've developed a VB code to open Excel files, and it works seamlessly on my PC with Excel 2007 and 2010. However, when I try to run the same code on another PC with Excel 2019 installed, I encounter a problem. The Excel file opens successfully, but only the cell editing option by double-clicking seems to be disabled in the form. Strangely, when I open the same Excel file directly in Excel 2019 without using the code, I can update cell values by double-clicking. The libraries used are Microsoft excel 12.0 and Microsoft office 12.0 Is there any specific settings that need to be enabled for Excel 2019 compatibility or if any code changes required to address this issue. Any help or suggestions would be greatly appreciated. Thank you!