ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo boxes and Protection (https://www.excelbanter.com/excel-discussion-misc-queries/32646-combo-boxes-protection.html)

[email protected]

Combo boxes and Protection
 
Hi all! I have a workbook with a number of worksheets with combo
boxes. I made sure to set the locked property to false for the combo
boxes, but whenever I try to select an item from my combo box I get the
following message:

The cell or chart you are trying to change is protected or read-only.

In the message I am informed to remove protection ... which of course
is not what I want to do.

Is there a solution to this problem. Thanks.



All times are GMT +1. The time now is 04:56 PM.

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