ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why can I change display value in locked ActiveX combobox? (https://www.excelbanter.com/excel-programming/313922-why-can-i-change-display-value-locked-activex-combobox.html)

Erik at VEIC[_2_]

Why can I change display value in locked ActiveX combobox?
 
I'm using an ActiveX combobox on a protected worksheet in Excel XP, and set
the Locked property to True. When I try to change the value, I get a message
saying that the cell is protected, as I would expect. The linked cell value
does not change, but the display value in the combobox does. This appears to
be a bug, but maybe I'm misunderstanding something. Any explanation?


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com