This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Well, the UI was changed in 2013 from MDI to SDI, so the behavior is a bit different in general. https://learn.microsoft.com/en-us/office/vba/excel/concepts/programming-for-the-single-document-interface-in-excel
But I never heard that this impact the way how you can edit a cell...
Andreas.