View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DocEE DocEE is offline
external usenet poster
 
Posts: 2
Default 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