ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo box drop down & worksheet protection (https://www.excelbanter.com/excel-discussion-misc-queries/110964-combo-box-drop-down-worksheet-protection.html)

DocEE

Combo box drop down & worksheet protection
 
I am using VBA code I found on Contextures to enlarge the font size of
dropdown lists by replacing them with a combo box upon double-clicking the
dropdown cell. The code works great until I protect the worksheet. I have
unlocked the dropdown cells and they are not linked to other cells. Any
suggestions? The code I'm using came from

http://www.contextures.com/xlDataVal11.html


All times are GMT +1. The time now is 02:21 AM.

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